![]() |
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? |
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 |
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