One-time NOW() function

[Guest]

When you enter the NOW() function in a cell, the current date/time info gets
put nito the cell. What I want is a one-time functioning of NOW() so that
the date and time that I enter NOW() into the cell remains the same. As
everyone knows, NOW() will get recalculated to the present each time
recalculation for that worksheet takes place. Thanks for any help anyone can
be.

 

[Guest]

Just type Ctrl-semicolon for a one-time date stamp

hth
Vaya con Dios,
Chuck, CABGx3

 

[Paul B]

BigD, You can use Ctrl+; to get the date and Ctrl+shift+; to get the time.
Will that do what you want?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gord Dibben]

Or CTRL + ;<space>CTRL + SHIFT + ; to enter both at once.


Gord Dibben MS Excel MVP