todays date formula

B

BigAl1322

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.
 
I

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.
 
B

BigAl1322

Thanks a lot Intruder 9 !!!

Intruder 9 said:
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.
Click to expand...
 
J

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.
 
Top