Ask Different is a question and answer site for power users of Apple hardware and software. 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

Is it possible to use the =today() function (or something else) to insert the current date but then not update each time the file is opened?

I want to create a numbers template for my invoices. I'd like it to auto fill invoice date and date due then, when I save the document, store the values, not the function.

share|improve this question

Go to Insert > Date & Time.


Double-click the date and format to taste. Make sure "Automatically update on open" isn't ticked.


share|improve this answer
Actually, depending on exactly how you plan to do this, you may want to fiddle around a bit with the Auto update setting. – timothymh Apr 3 '12 at 0:22
hey thanks heaps just wondering do you know why insert date & time would be greyed out? – Mitchell Apr 3 '12 at 0:44
If don't have the cell selected and ready to type into you can't insert into it – Alex Apr 3 '12 at 2:01
yeah i know that thanks must be playing up i will try areset – Mitchell Apr 3 '12 at 2:34

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.