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

3 Answers 3

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

 
discard

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.