13

I want to insert date and time into a cell of an Excel spreadsheet. NOW() and TODAY() don't fit my needs. These functions insert dynamic date. But I want static: if I insert the date it won't change with time.

28
+50

To insert the current date, hold control and press the semicolon key. This will quickly insert the current date in a non-dynamic way.

Control + ; will insert the date
Control + Shift + ; will insert the time.

  • for me, this simply does not work. It worked before my last windows reinstall. What do you suggest? – Radu Simionescu Jun 6 '13 at 5:25
1

Type it.

Make sure to set the cell type as date.

(Mokubai's answer is much better though!)

1

You can copy > paste special > value then it won't change. You can use this for all sorts of formulas, such as RAND().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.