You can change the base date for a date column to one of the following:
|1/3/1600||The nominal starting day for the Gregorian calendar.|
|1/1/1900||The starting day used by spreadsheets such as Excel, Lotus and Quattro.|
- Put the cursor in the spreadsheet column you want to change then select Spread | Calculate | Rebase Dates.
- When the warning prompt appears click Yes.