1

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 ?

Improve this question
2
  • 1
    No. Not unless you use VBA
    – brettdj
    Apr 8, 2013 at 10:30
  • Copy and paste values is your only option. Formulas will always re-compute
    – glh
    Apr 8, 2013 at 11:26

1 Answer 1

Reset to default
5

Source Insert a static date or time:

  • Ctrl+; for Date
  • Ctrl+Shift+; for Time
  • both in sequence for Date+Time
Improve this answer

You must log in to answer this question.

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