enter time or date to a cell for time sheet

[kirk]

I want to be able to enter the date into a cell.
I know about =today(), but that put in the present date
and updates each day you enter the file. I want to be able
to go to a cell that is formated for date hit enter and it
automatically inserts the date and that date doesn't change
or be able to enter it manually.
Word has this function why doesn't excel?
Is there a mcaro out there that would do this?

 

[JMay]

You can Ctr+: (that's a semi-colon)
Date will not change..
HTH

 

[pfsardella]

For reference, these two WebPages have good info on shortcut keys.

http://www.cpearson.com/excel/ShortCuts.htm
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

1. Enter the date CTRL+; (semicolon)
2. Enter the time CTRL+SHIFT+: (colon)

HTH
Paul