Issues with 1900 & 1904 base date

G

Getwild2

All,

I'm having the cross-platform issue with the base dates 1900/1904 that we all
know and love.

I've followed the steps below (in quotes) from the following thread:
http://www.mackb.com/Uwe/Forum.aspx...n-the-1900-1904-date-systems-Mac-to-Win-Users


"1. Create a Workbook with the 1900 base date and other standard formats that
you want for a workbook and then save in /Applications/Microsoft Office
2008/Office/Startup/Excel as Workbook (template) with no File Extension.
2. Create a single sheet with the 1900 base date and other standard formats
that you want for a new sheet and save in /Applications/Microsoft Office
2008/Office/Startup/Excel as Sheet (template) with no file extension."

Well it sort of works... In following step #1 my initial Excel workbook has
the 1900 base date setting, however every subsequent workbook does not. For
instance if I "Command+N" or select "New" from the toolbar the workbook that
opens has the 1904 base date. From reading the thread in the above link I
believed the two steps below would solve the issue with "initial" AND
"subsequent" workbook creations.

Your thoughts??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top