View Single Post
Old 09-02-2009, 08:46 PM   #5 (permalink)
monkeypaw
BlackBerry Extraordinaire
 
Join Date: Oct 2007
Location: Los Angeles
Model: None
PIN: N/A
Carrier: ATT
Posts: 1,638
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's the link:
Description of the differences between the 1900 date system and the 1904 date system in Excel

To set the date system for a workbook in Microsoft Office Excel 2003 and in earlier versions of Excel, follow these steps:

1. Open or switch to the workbook.
2. On the Tools menu, click Options. In Excel X and later versions for Macintosh, click Preferences on the Excel menu.
3. Click the Calculation tab.
4. To use the 1900 date system in the workbook, click to clear the 1904 date system check box. To use the 1904 date system in the workbook, click to select the 1904 date systemcheck box.
5. Click OK.

To set the date system for a workbook in Microsoft Office Excel 2007, follow these steps:

1. Open or switch to the workbook.
2. Click the Microsoft Office Button, and then click Excel Options.
3. Click Advanced.
4. Click to select the Use 1904 data system check box under the When calculating this workbook, and then click OK.
Offline   Reply With Quote