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.