OpenOffice Calc - How to change the default date format?

Ask a question


Issue


How to change the default date format under OpenOffice Calc?

Solution

  • In your spreadsheet, click on the "Format" menu > Cells > Numbers
  • In the "Category" field, select "Date"
  • Next choose the date format in the Format field:
  • Click on Ok to validate.

Open Office - Decimal point is replaced by a comma!
OpenOffice Calc - Enable regular expressions in formulas