Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you "Time Stamp" in Excel?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you "Time Stamp" in Excel?
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you "Time Stamp" in Excel?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need IF statement to categorize time into "Morning", "Afternoon", "Evening" | Excel Discussion (Misc queries) | |||
How can I put/insert a "Paid" stamp on an invoice created in Excel | Excel Discussion (Misc queries) | |||
How do I put a "date & time saved" stamp inside an Excel Wksht? | Excel Programming | |||
How do I put a "date & time saved" stamp inside an Excel Wksht? | Excel Programming | |||
Can I make time stamp function that "sticks"? | Excel Programming |