How to change default date format OpenOffice Calc

How to change default date format OpenOffice Calc

OpenOffice Calc is a highly popular program thanks to its possibilities to create graphs, formulas, edit spreadsheets and perform complicated calculations. The software is also very customizable: you can set up multiple settings for the handiest usage. Read this article to find out how to change the default date format on OpenOffice Calc.

To change the default date format using OpenOffice Calc

  • In your spreadsheet, click on the Format > Cells > Numbers;
  • In the Category field, select Date;
  • Next, choose the date format in the Format field.
  • Finally, click OK to validate.
More Office software questions? Check out our forum!

Subject Replies
MS Word not displaying page numbers, images 54
How to convert number into text in Excel 9
Why do my PDF documents open in Word? 32
How to convert the tamil pdf file to tamil word file 11
Problem scrolling with arrow keys (IE7) 40
Excel - IF function with multiple words 14
If a cell contains any text then add a value 20
Removing " false" value in "IF" 10
Short cut to merge cells 17
Find word within cell & put value in adjacent 39

OpenOffice