Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

To datestamp a cell in Excel I use the forumula : =NOW()

The problem is that as I datestamp new cells all other cells which contain the formula NOW() are updated with the new datestamp. Is there a formula I can use which will just datestamp the cell once, and not recompute the date each time ?

share|improve this question

migrated from stackoverflow.com Apr 8 '13 at 12:08

This question came from our site for professional and enthusiast programmers.

1  
No. Not unless you use VBA – brettdj Apr 8 '13 at 10:30
    
Copy and paste values is your only option. Formulas will always re-compute – glh Apr 8 '13 at 11:26
up vote 5 down vote accepted

Source Insert a static date or time:

  • Ctrl+; for Date
  • Ctrl+Shift+; for Time
  • both in sequence for Date+Time
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .