You can enter the date with CTRL+<semi-colon . It will not
update.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"DWilliams" wrote in
message
...
How do i automatically enter a date that does not change
everyday like it
does with the now() function?
--
DW