Forum Discussion
Date system 1904
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
To set the 1904 date system for new workbooks:
- Create a new workbook.
- Set it to use the 1904 date system.
- If you wish, set other preferences, such as the Normal style.
- Select File > Save As.
- Select Excel template (*.xltx) from the Save as type dropdown.
- Enter %appdata%\Microsoft\Excel\XLSTART\Book.xltx in the File name box.
- Click Save.
From now on, when you press Ctrl+N or click New on the Quick Access Toolbar, Excel will use this template.