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
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
"Marc" <Marc@discussions.microsoft.com> wrote in message
news:BEBE7F5A-0329-4DB2-8A33-DE8ACBE05C07@microsoft.com...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks