1904 date

[Eng Khoon]

My colleagues at the office use Windows Excel and we share many worksheets
in our work. This gives rise to a problem when I have to copy dates to or
from their worksheets because Windows Excel uses 1900 dates while Mac
Excel's default is 1904.

Because I'm outnumbered, I have to be the one to amend my worksheets to
comply with the 1900 date. While I can uncheck the 1904 date box in the
Preferences pane, Mac Excel resets it whenever I open a new worksheet.

Is there anyway to permanently uncheck the 1904 date box?

Any help will be much appreciated. Thanks.


regards
engkhoon

 

[J.E. McGimpsey]

My colleagues at the office use Windows Excel and we share many worksheets
in our work. This gives rise to a problem when I have to copy dates to or
from their worksheets because Windows Excel uses 1900 dates while Mac
Excel's default is 1904.

Because I'm outnumbered, I have to be the one to amend my worksheets to
comply with the 1900 date. While I can uncheck the 1904 date box in the
Preferences pane, Mac Excel resets it whenever I open a new worksheet.

Is there anyway to permanently uncheck the 1904 date box?

Any help will be much appreciated. Thanks.

The Date system is a workbook-level setting, so existing workbooks
will keep whatever setting they have until you change and save them.
You can make a template, however, that has the date system set to
1900, and any workbooks made from that template will also have the
1900 date system.

To make all *new* workbooks have the 1900 system, create a new
workbook, set the date system to 1900 and save it as a Template with
the name "Workbook" (no quotes, no extension) in the Microsoft
Office N:Office:Startup:Excel folder (where N is your version).

 

[Steve]

The Date system is a workbook-level setting, so existing workbooks will
keep whatever setting they have until you change and save them. You can
make a template, however, that has the date system set to 1900, and any
workbooks made from that template will also have the 1900 date system.

To make all *new* workbooks have the 1900 system, create a new
workbook, set the date system to 1900 and save it as a Template with
the name "Workbook" (no quotes, no extension) in the Microsoft Office
N:Office:Startup:Excel folder (where N is your version).

Hi,

This approach doesn't seem to work for workbooks created as a result of
a file import via the Text Import Wizard, any suggestions?

 

[JE McGimpsey]

This approach doesn't seem to work for workbooks created as a result of
a file import via the Text Import Wizard, any suggestions?

When you import a text file using the Text Import Wizard, the text date
will be converted to an XL date in accordance with the date system of
the workbook you import the data into.