OpenOffice Calc - How to change the default date format?

July 2017



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.

Related


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 (ccm.net).