Hi,

Am Wed, 15 Apr 2015 11:07:07 -0700 (PDT) schrieb :

Is there a way to make a cell create a time stamp when you want it to and then stick to that date/time for ever? So when you open the file the next day the time stamp doesn't update to the current date/time? Thanks.

you have to do it with VBA.
For example:

Sub TS()
With Range("A1")
.Value = Now
.NumberFormat = "MM/DD/YYYY h:mm:ss"
End With
End Sub

Modify the numberformat to your expected format.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional