OpenOffice Calc - How to change the default date format?

April 2018



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.
Published by deri58. Latest update on March 23, 2013 at 07:05 AM by deri58.
This document, titled "OpenOffice Calc - How to change the default date format?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Open Office - Decimal point is replaced by a comma!
OpenOffice Calc - Enable regular expressions in formulas