HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roberto - 25 Jun 2006 09:55 GMT

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?

Reply to this Message

Leith Ross - 25 Jun 2006 10:10 GMT

Hello Roberto,

Place the forumla =TODAY() in the cell or cells you want to display the
date.

Sincerely,
Leith Ross

Signature

Leith Ross

Reply to this Message

Don Guillett - 25 Jun 2006 12:47 GMT

Pls post in only ONE group,

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi all,
> is there any way to show date automatically when i open my excel
[quoted text clipped - 3 lines]
> it as *.xls file. When i open the file it will show current date in a new
> columns? is it possible?

Reply to this Message