1904 date

External Since: Feb 26, 2004 Posts: 7

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

External Since: Dec 25, 2003 Posts: 551

In article <BBE056CC.6CA8%cek@ssc.com.my>,
Eng Khoon <cek DeleteThis @ssc.com.my> wrote:

> 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).