One-time NOW() function
 

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

One-time NOW() function
 

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

hth
Vaya con Dios,
Chuck, CABGx3



"BigD" wrote:

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

One-time NOW() function
 

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

"BigD" wrote in message
...
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.
--
BigD

One-time NOW() function
 

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


Gord Dibben MS Excel MVP



On Thu, 28 Sep 2006 12:29:55 -0400, "Paul B"
wrote:

BigD, You can use Ctrl+; to get the date and Ctrl+shift+; to get the time.
Will that do what you want?