ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? (https://www.excelbanter.com/excel-programming/365300-how-do-i-set-dates-show-my-spreadsheet.html)

Roberto

HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
 
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?

Leith Ross[_599_]

HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
 

Hello Roberto,

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

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=555332


Don Guillett

HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
 
Pls post in only ONE group,

--
Don Guillett
SalesAid Software

"Roberto" wrote in message
...
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?





All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com