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

Possible Duplicate:
How to insert a date into an Excel spreadsheet?

For example, I have the formula =NOW() but I want the date to be fixed as today's date. I don't want it to change tomorrow.

Is there a way to change the formula to make sure it only reflects the date today? Or how can I do that?

I don't want to Paste Special if possible.

share|improve this question

marked as duplicate by Mike Fitzpatrick, Synetech, 8088, Paul, Simon Sheehan Nov 14 '12 at 1:33

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

You can do this with keyboard commands.

To enter current date: Ctrl + ;
To enter current time: Ctrl + Shift + ;

share|improve this answer

F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.


Do it on your =NOW() formula, and it should stay fixed.

share|improve this answer

I would try inserting the current date into a cell via a macro. The question then only is, when and how to trigger that. You could for example press a button and it would insert today's date (not as a formula) into a cell (one particular or the selected one).

In VBA you can use Now(), Date() and Time(), depending on what you need exactly. With Range("d40").Value = Date() associated to a shape it will insert the current date without the time into Cell D40 when you click the shape.

share|improve this answer

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