Feb 22 2021 10:10 PM
Hi
With excel 365 dates are automatically set in system 1900 for all new worksheets
How to have system 1904 automatically for all new worksheets ?
Thanks
Chrigu
Feb 23 2021 02:12 AM
Differences between the 1900 and the 1904 date system in Excel
(click on header for more infos)
Setting the Date System for a Workbook
In Excel, each workbook can have its own date system setting, even if multiple workbooks are open.
To set the date system for a workbook in Microsoft Office Excel 2003 and in earlier versions of Excel, follow these steps:
To set the date system for a workbook in Microsoft Office Excel 2007, follow these steps:
Notice that if you change the date system for a workbook that already contains dates, the dates shift by four years and one day. For information about how to correct shifted dates, see the "Correcting Shifted Dates" section.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Feb 23 2021 02:49 AM
To set the 1904 date system for new workbooks:
From now on, when you press Ctrl+N or click New on the Quick Access Toolbar, Excel will use this template.