Add timestamp to sheet entry in Excel
For example, in the "Last Updated On" field in my Worksheet as shown below, I would like to enter the System Date and Sytem Time (not manually). I understand Today() and Now() are volatile functions and they keep changing.
To do it in Excel, here is the answer:
a) Select the cell. Click on "Ctrl + ;" to get the System Date as shown below.
b) Enter comma followed by space and then press "Ctrl + Shift + ;". System time is also added as shown below.