"Now" Function

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

How do you keep the "now" function from updating the date when you open the
spreadsheet at a later date?
 
Don't use the NOW (or TODAY) function, as this will always
recalculate.

You can fix the values of those formulae to stop them changing.

You can use CTRL with : (colon) to get a date-stamp, and/or CTRL
with ; (semicolon) to get a time-stamp.

Hope this helps.

Pete
 
Kenneth said:
How do you keep the "now" function from updating the date
when you open the spreadsheet at a later date?
Click to expand...

You can't use formulas as the "date/time stamps" as these will recalc

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
 
Hi,

the whole point of =NOW() and =TODAY() is to provide a date that always
updates. If you suppress the calculation of the spreadsheet these functions
will not update, but neither will anything else.

If you want a date that doesn't update just type it in - 1/22/2009 for
example, or use the shortcuts suggest by Pete which input the Current date or
Current time as indicated by the computer's clock and calendar.

To enter the date and time as hard coded equivalent of NOW in one cell -
press Ctrl+; space Ctrl+:
 
is there a way to use only date for a trigger. What I am trying to do is have
an event happen on the 15th of each month. regardless of year etc.
Thanks for any input I am going nuts
Appreciate help
 
Back
Top