HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?

R

Roberto

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?
 
W

wowster0

Roberto said:
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?
Click to expand...

Hi

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

Hth

Steve
 
D

Don Guillett

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

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

Don Guillett

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