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.

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.

3 Answers 3

You can do this with keyboard commands.

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

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

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.

Source: http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx

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

share|improve this answer

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