date
 

how to set the date to appear Automaticaly, when i open excel

date
 

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

=TODAY()
--
David Biddulph

"amir" wrote in message
...
i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

yes, but i have to type that code every time i open excel.What i really want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.

"David Biddulph" wrote:

=TODAY()
--
David Biddulph

"amir" wrote in message
...
i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
--
David Biddulph

"amir" wrote in message
...
yes, but i have to type that code every time i open excel.What i really
want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.

"David Biddulph" wrote:

=TODAY()
--
David Biddulph

"amir" wrote in message
...
i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

atlast....thanks

"David Biddulph" wrote:

If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
--
David Biddulph

"amir" wrote in message
...
yes, but i have to type that code every time i open excel.What i really
want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.

"David Biddulph" wrote:

=TODAY()
--
David Biddulph

"amir" wrote in message
...
i want the date to appear Automaticaly,in a cell when i open excel

"Gordon" wrote:

"amir" wrote in message
...
how to set the date to appear Automaticaly, when i open excel


Appear WHERE?

date
 

"amir" wrote in message
...
atlast....thanks


But you have to SAVE that sheet and open that one - if you open a NEW sheet
then it WON'T have the date in it...