date

  • Thread starter Thread starter Guest
  • Start date Start 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.
 
If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
 
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.
Click to expand...
 
amir said:
atlast....thanks
Click to expand...

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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

outlook2003 question 1
How do I keep my name from appearing in the comment box in excel 2
conditional formatte date in a1 calculate the date in A2 3
Moving Data Automaticaly 3
On open goto today 2
i need to know that.... 5
excel file opened automaticaly at specified time & date 2
how to auto copy the value of B3 to E5? 1

Back
Top