Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers

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.

share|improve this answer
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
add comment

Type it.

Make sure to set the cell type as date.

(Mokubai's answer is much better though!)

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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