Setting the date system (1900) on Mac Office 2008

How do you set the date system 1900 vs 1904 on Mac Office 2008?
-Ron-Asked:
Who is Participating?
 
strungConnect With a Mentor Commented:
Also:  http://support.microsoft.com/kb/303216

which says:

How to Transfer Files Between Excel for the Macintosh and Excel for Windows By default, Excel for the Macintosh uses the 1904 date system,               and Excel for Windows uses the 1900 date system. This means that when you type               the serial number 1 in Excel for the Macintosh and format it as a date, Excel               displays it as 1/2/1904 12:00 a.m. Excel for Windows displays the serial number 1 as 1/1/1900 12:00 a.m. If you transfer files from Excel for the Macintosh to Excel for               Windows, this difference in the date systems should not cause a problem,               because the date system is stored in each file. However, if you copy and paste               between files with different date systems that originated on different               platforms, dates may be displayed four years and one day away from their               correct date.

In Microsoft Excel for Mac, you can change to the 1900 date system by clicking Preferences (on the Edit menu in Excel 2001 for Mac, or on the Excel menu in later versions), clicking the Calculation tab, and then clicking to clear the  1904 date system check box. In Excel for Windows, you can change to the 1904 date system by clicking Options on the Tools menu, clicking the Calculation tab, and then clicking to select the 1904 date system check box.
0
 
strungCommented:
0
 
Philip_SparkCommented:
XL uses the date system of the first workbook that is opened, so you can  
 
do this by setting up a default workbook. See the "default workbook  
 
template" topic in XL Help.  
 
Specifically, create a new workbook. Arrange it the way you want (e.g.,  
 
number of worksheets, formatting). Set the date system to 1900. Save the  
 
workbook as a template with the name "Workbook" (no quotes, no  
 
extension" in your Startup directory (by default, the  
 
HD:Applications:Microsoft Office 2004:Office:Startup:Excel:
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Philip_SparkCommented:
yours of course would be

HD:Applications:Microsoft Office 2008:Office:Startup:Excel:
0
 
-Ron-Author Commented:
This is good information - but only shows how to change in the Windows program - I need to have a Mac user change on the Mac side but I don't have a Mac handy to look at the options -but evidently the options are not the same as those described for the Win Excel
0
 
-Ron-Author Commented:
Thanks Philip


Exactly how do you -"Set the date system to 1900"?



XL uses the date system of the first workbook that is opened, so you can  
 
do this by setting up a default workbook. See the "default workbook  
 
template" topic in XL Help.  
 
Specifically, create a new workbook. Arrange it the way you want (e.g.,  
 
number of worksheets, formatting). Set the date system to 1900. Save the  
 
workbook as a template with the name "Workbook" (no quotes, no  
 
extension" in your Startup directory (by default, the  
 
HD:Applications:Microsoft Office 2004:Office:Startup:Exc
0
 
strungCommented:
Sorry about that. Try this link instead:  http://support.microsoft.com/kb/214330
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.