Print Modified date stamp on excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to have the last date modified stamp print on an excel sheet to
ensure current modified version is being used. Does anyone know how to do
this?

Thank You
 
In the cell you want the message displayed enter the formula -

=TODAY()



Format that cell as custom and, in 'type', enter

"The message you want displayed" dd/mm/yyyy


If you want to retain the date on which the spread sheet was last updated
you will also need to make sure the spreadsheet is updated manually. To do
this-

Click on <Tools><Options><Calculations><Manual>

Otherwise (if it is updated automatically) it will always show today's date.


Regards.

Bill Ridgeway
Computer Solutions
 
This works just the way you stated, but only on the first save. If I stay
working in the document and hit save again the time won't update again. Can
this be fixed?
 
Back
Top