Tell us what you tried, and why it didn't do what you want. Then we're better
able to help you.

--
Regards,
Fred


"Pezacide" wrote in message
...
what is the custom format for the date/time format
Wednesday, 17 October 2007, 15:25

"Fred Smith" wrote:

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I
keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.