Locking Dates in Excel

J

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. :
 
J

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
 
H

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
 
J

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
 
J

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
 
Top