On Wednesday, April 15, 2015 at 2:10:58 PM UTC-4, Claus Busch wrote:
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

Thanks for the response, but I wasn't following. Below is my exact situation. Can you advise me on how to do it?

Cell L115 is blank. I would like cell M115 to have the time stamp. If I type an x in cell L115, I would like cell M115 to show 04/15/15. Even if I open the file tomorrow I would still want M115 to show 4/15/15. Thanks.