Is there a Timestamp function that does not update in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function or a formula that will create a timestamp in a cell
without it being updated when the spreadsheet is saved? Like a =NOW()
function that isn't updateable or can you make the =NOW() function where it
doesn't update?
 
From Excel Help -

Insert the current date and time in a cell
Insert a static date or time

Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;

Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want to track time while paste value in multiple column of same roe 1
Timestamp function that does not update in Excel? 1
Need a Static Timestamp Formula 2
Now as timestamp 5
How to decode integer timestamps? 8
TimeStamp Record 7
Timestamp Macro 1
TimeStamp 2

Back
Top