HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?

[Guest]

Hi all,
is there any way to show date automatically when i open my excel spreadsheet?
for instance, if i exported a file that has 100 rows and 5 columns and save
it as *.xls file. When i open the file it will show current date in a new
columns? is it possible?

 

[wowster0]

Hi all,
is there any way to show date automatically when i open my excel
spreadsheet?
for instance, if i exported a file that has 100 rows and 5 columns and
save
it as *.xls file. When i open the file it will show current date in a new
columns? is it possible?

Hi

If I understand correctly try =now() in your column

Hth

Steve

 

[Don Guillett]

right click the excel icon next to FILE>view code>left window>workbook>right
window>workbook_open

sheets("sheet1").range("a1")=date

 

[Don Guillett]

And Please, in the future, post in ONLY one group.
the answers using =now() or =today() will change on EACH calculation