Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

19xx/20xx Years

The year in a date entry is often entered as two digits. Internally, the year is managed by Office as four digits, so that in the calculation of the difference from 01/01/99 to 01/01/01, the result will correctly be two years.

  • Under Tools - Options - Office - General you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029.

This means that if you enter a date of 01/01/30 or higher, it will be converted to the internal date 1930-01-01 or higher. All lower two-digit years are converted to the 20xx century. So, for example, 01/01/20 is converted into 2020-01-01.