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
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
---
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+:
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Curt" <Cu...@discussions.microsoft.com> wrote in message
news:929E594F-3BE1-44A1...@microsoft.com...
To implement a correct time-stamp mechanism it is sometimes necessary
to "rebuild" the time-stamping formula; have a look at
http://www.excelforum.com/excel-programming/390157-functions-wont-calculate-without-f2.html
Cheers Michael