G
Guest
how to set the date to appear Automaticaly, when i open excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gordon
amir said:how to set the date to appear Automaticaly, when i open excel
Appear WHERE?
G
Guest
i want the date to appear Automaticaly,in a cell when i open excel
D
David Biddulph
=TODAY()
--
David Biddulph
--
David Biddulph
amir said:i want the date to appear Automaticaly,in a cell when i open excel
G
Guest
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.
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.
D
David Biddulph
If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
date will appear in that cell and be updated.
G
Guest
atlast....thanks
David Biddulph said:If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
G
Gordon
amir said: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...