Date : =today()

T

Tony Guzzo

If I use =today() on a work sheet, is it possible to make the date " not
change " the folowing days, Tony
 
G

Gary L Brown

Only by making the cell a value.
Type =today() then hit the 'F9' key THEN hit ENTER.
HTH,
 
B

Bob Phillips

or Ctrl-; (semi-colon)

--
HTH

Bob Phillips

Gary L Brown said:
Only by making the cell a value.
Type =today() then hit the 'F9' key THEN hit ENTER.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".
 
S

SITCFanTN

I've been scanning past posts to find the answer to my questions and I found
this, my question is how do I preserve my today date with code so it does not
change tomorrow. Thanks
 
D

Dave Peterson

control-semicolon
will put the current date in the cell--and it won't change.
 
Top