Excel Formula - Date Fixing

  • Thread starter Thread starter Aajt8888
  • Start date Start date
A

Aajt8888

I have entered the following into a worksheet =IF(A9=0,0,NOW()) the ai
is that if anything is entered into the cell A9 the date will b
logged. However everytime I open the workbook it just loads the curren
dat
 
Hi Aajt!

Put the time in using:

Ctrl + Shift + :

You can put date and time in using:

Ctrl+; [space] Ctrl+Shift+:

These take date and time from the system clock and won't change once
they are entered.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top