Locking Dates in Excel

[jamesmac]

I am entering the current date in cells using the Now command
Unfortunately that date updates as the date changes.
How can I use a formula to eneter a date then have it fixed so that i
does not change. :

 

[JulieD]

Hi

instead of using =now() you could use the short cut keys of
ctl & ;
for the date
and ctrl & shift & ;
for the time

these are static and won't change.

Cheers
JulieD

 

[Harald Staff]

You can't. Formulas are supposed to change or update on recalculation. You
can enter a permanent no-formula date with key combination Ctrl ; (ctrl
semicolon) or by macro code Range("A1").Value = Date

HTH. Best wishes Harald

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

 

[jamesmac]

Thanks to Harald and Julie.
I had used your suggestion Julie in my Macro but that wouldnt wor
correctly
I used Haralds suggestion and included his suggestion in my macro an
now can carry out this task.
Once again many thank

 

[JulieD]

Hi

glad it's solved .. no my suggestion won't work in a macro - i didn't gather
from your post that you were actually using a macro to enter the date.

Cheers
JulieD