Time & Date Formatting
 

I have a 'now' format in a worksheet for inserting date and time. Once I have
saved the sheet, I want to retain the original time / date, and not have it
change every time I re-open the document. Any ideas?

You cannot do that with

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Goodvibes" wrote in message
...
I have a 'now' format in a worksheet for inserting date and time. Once I
have
saved the sheet, I want to retain the original time / date, and not have
it
change every time I re-open the document. Any ideas?

Try again :-)

You cannot do that with a formula. Just enter a time value with Ctrl-; then
a space then a Ctrl-Shift-:. This will 'hard-code' today's date and then the
current time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Goodvibes" wrote in message
...
I have a 'now' format in a worksheet for inserting date and time. Once I
have
saved the sheet, I want to retain the original time / date, and not have
it
change every time I re-open the document. Any ideas?

Hi
also see:
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany
"Goodvibes" schrieb im Newsbeitrag
...
I have a 'now' format in a worksheet for inserting date and time. Once I
have
saved the sheet, I want to retain the original time / date, and not have
it
change every time I re-open the document. Any ideas?