numbers auto date

[mert]

How can I create a function that will put in today's date automatically into a table cell? I don't want to manually do it, i need "numbers" to acquire this information automatically from my computer.

 

[Mal]

Depending on what you want exactly, there are two possible methods.

To enter the current date and not have it change the next time you open the file, use Control-; (semicolon). Also, to enter the time instead, use Command-;

To enter the current date and have it autoupdate each time you open the file (good for templates or invoicing, etc), use the function =TODAY(). If you enter that (and that alone) in a cell, that cell will always display the current date, updating each time you open the file.

jW

 

[mert]

depending on what you want exactly, there are two possible methods.

To enter the current date and not have it change the next time you open the file, use control-; (semicolon). Also, to enter the time instead, use command-;

to enter the current date and have it autoupdate each time you open the file (good for templates or invoicing, etc), use the function =today(). If you enter that (and that alone) in a cell, that cell will always display the current date, updating each time you open the file.

Jw

thank you indeed. It worked just as i needed.

Mert

 

[satcomer]

I use TextExpander and just love. It has made me much more productive in typing, very quickly.