Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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
add comment

1 Answer

Go to Insert > Date & Time.

Menu

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

Format

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
add comment

Your Answer

 
discard

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.