[Year 12 IT Apps] Excel Question Attachment included

Geoff Moss geoffmoss37 at optusnet.com.au
Wed Aug 15 11:18:29 EST 2007


Hi David

OOPS forgot attachment in previous.

Attached is an illustration of how to save the date when an order is 
made rather than the current date    =now().

It may be useful for students to view the process with the screen dumps 
provided.

You will notice the current date and time in cell A1.  Cell A3 is a copy 
and paste of cell A1.

In cell A5 you will notice that there is a significant time difference 
in the time.  The data in cells A3 and A5 were copied in the same 
timeframe (except for a few seconds).

I have noticed that the time has stalled in cells A1 and A3.  To 
demonstrate the difference in time I found that if I typed =now() in 
another cell, say F1, the dates in A1 and A3 changed to the current 
time.

Regards

Geoff Moss
RMIT




> David Howard <DHoward at padua.melb.catholic.edu.au> wrote:
> 
> Hi All,
> 
> Yes yet another excel question. Is there any way when copying data from
> a cell to make it not copy the formula and copy only the value from the
> formula? Ie cell a1 has in it =date() or 14/08/2007 when this is copied
> it copies the formula =date() so the problem is that if an order is made
> today for instance and you want a macro to save the date that the order
> was made, then the order will always be made on the current date.
> 
> Confused?
> 
> Also, is there anyway to make a cell count as an autonumber like in
> access?
> 
> Regards
> 
> David Howard
> Padua College
> 
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Brendyn Hancock
> Sent: Tuesday, 14 August 2007 9:37 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Show file extensions?
> 
> All
> 
> This is a very good question.
> 
> We have file .ext turned on. The kids who need to be assured that they
> have the correct ext find it useful but most of the others kids have no
> idea. In fact most of them (because their machines at home by default
> have ext turned off I suspect) delete the ext because they didn't put
> that 'funny bit at the end' on so they just don't bother with it when
> they rename.
> 
> We have most of our issues because it's on.
> 
> I reckon the most difficult thing to teach in IT is file management.
> 
> Bring back windows explorer or even better still Xtree Gold....
> 
> Brendyn
> 
> Brendyn Hancock
> IT Manager
> bhancock at nagle.sale.catholic.edu.au
> ---------------------------------------------
> Nagle College
> 5152 6122
> Bairnsdale VIC 3875
> 
> 
> >>> Russell Edwards <edwards.russell.t at edumail.vic.gov.au> 14/08/2007
> 8:54 am >>>
> A quick question:
> 
> Does your school have Windows set up for students to show them the  
> file extensions, or not?  What do you think about the policy?
> 
> Ours doesn't show them the extensions. I can see why this may be less 
> 
> confusing for staff and students with low skill levels, however for  
> the better students it is probably _more_confusing. At times it's  
> downright annoying, for example when teaching them HTML and telling  
> them to guess the extension of an image they wish to include... not  
> to mention explaining to them why the file they saved from Notepad as 
> 
> "page1" (.txt) doesn't  load up in IE the other "page1" (.htm) does.
> 
> Interested to hear what other schools do.  While I'm at it, I'm  
> frustrated by the lack of the right-click menu in windows explorer  
> for students, and also the blocking of Task Manager--- but I suppose  
> there may be security reasons for these.
> 
> Russell
> 
> 
> Important - This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before
> opening or using attachments check them for viruses and defects.
> Regardless of any loss, damage or consequence, whether caused by the
> negligence of the sender or not, resulting directly or indirectly from
> the use of any attached files our liability is limited to resupplying
> any affected attachments. Any representations or opinions expressed are
> those of the individual sender, and not necessarily those of the
> Department of Education.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> `*;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
> Important - This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before
> opening or using attachments check them for viruses and defects.
> Regardless of any loss, damage or consequence, whether caused by the
> negligence of the sender or not, resulting directly or indirectly from
> the use of any attached files our liability is limited to resupplying
> any affected attachments. Any representations or opinions expressed are
> those of the individual sender, and not necessarily those of Nagle
> College, Bairnsdale. 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> E-MAIL DISCLAIMER 
> This e-mail and any files transmitted with it contain confidential 
> information intended for the use of the individual or entity named 
> above. If you are not the intended recipient of this e-mail you are 
> hereby notified that you must not disseminate, copy or take action in 
> reliance upon it. If you have received this message in error, please 
> notify the sender immediately by return e-mail or telephone Reception at 
> Padua College on (03) 5976 0100.
> 
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Retain date.xls
Type: application/octet-stream
Size: 40448 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070815/5d77e7b8/Retaindate-0001.obj


More information about the itapps mailing list