todays date formula
 

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.

todays date formula
 

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.
"BigAl1322" wrote in message
...
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.

todays date formula
 

Thanks a lot Intruder 9 !!!

"Intruder 9" wrote:

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.
"BigAl1322" wrote in message
...
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.

todays date formula
 

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

"BigAl1322" wrote in message
...
Thanks a lot Intruder 9 !!!

"Intruder 9" wrote:

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.
"BigAl1322" wrote in message
...
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.