Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

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