Can you "Time Stamp" in Excel?
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.
|
Can you "Time Stamp" in Excel?
|
Can you "Time Stamp" in Excel?
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. |
Can you "Time Stamp" in Excel?
|
Can you "Time Stamp" in Excel?
|
All times are GMT +1. The time now is 06:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com