todays date formula

[Guest]

Office XP - Excel

I want to insert "today's date" formula into a celll when I start working on
a spreadsheet that will not change the next time I open the spreadsheet.

 

[Intruder 9]

If you don't want it to change what do you need a formula for just press the
CTRL key and the : key, this will insert the date.

 

[Guest]

Thanks a lot Intruder 9 !!!

If you don't want it to change what do you need a formula for just press the
CTRL key and the : key, this will insert the date.

 

[jeffg]

-Record a macro of this keystroke and associate it with a button if your
working from a template ..you can use fixed or relative referencing
depending on what your particular needs are..
on my projects I usually include a Sub Workbook_open() in the Workbook Vba
pane and copy in a macro of the keystroke with absolute referencing to the
particular destination cell.