Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

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

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

Type it.

Make sure to set the cell type as date.

(Mokubai's answer is much better though!)

share|improve this answer

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

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.