ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? (https://www.excelbanter.com/excel-discussion-misc-queries/95915-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?

Toppers

HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
 
See reply in worksheet.functions.

And PLEASE only post a question to one NG to avoid duplication of replies.

"Roberto" wrote:

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 11:23 PM.

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