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.

1 Answer 1


Go to Insert > Date & Time.


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


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

You must log in to answer this question.

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