[Year 12 IT Apps] Excel Question

Tue Aug 14 11:11:38 EST 2007

Hi David,
	Have you tried using 'paste special' and 'paste values' only?
Cheers
Damien AB
Keilor Downs College

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of David Howard
Sent: Tuesday, 14 August 2007 10:55 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Excel Question

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

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.