I see. Thanks, this looks like it works!

"Roger Govier" wrote:

Hi

You can't use a formula (as it will change each time as you have found).
That is why others have suggested a VBA solution to provide the date or
timestamp..
If you want to enter to a cell manually, then

To enter Date into a cell type Ctrl + ; - that's Control + semicolon
To enter Time into a cell type Ctrl + : - that Ctrl + colon or Ctrl
+ Shift + semicolon
--
Regards

Roger Govier


"DRK" wrote in message
...
Hopefully a formula...I'd like to include it in a cell.

"ducky" wrote:


DRK wrote:
How do I insert a timestamp for the last time a sheet was saved?
I've looked
at the NOW and TODAY functions, but these change each time I open
the sheet.
I only want the formula to change IF I save the sheet. Can anyone
offer any
suggestions?

are you looking for VBA code or a formula?

AR