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.


Go to Insert > Date & Time.


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


| 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. – Timothy Mueller-Harder 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

You must log in to answer this question.

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