One-time NOW() function

B

BigD

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.
 
P

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top