Ask Your Question

How to setup Format cells > Date > mm/dd/yyyy as default

asked 2019-08-26 07:37:59 +0100

lonk gravatar image

updated 2019-08-26 07:38:23 +0100

In order to see the difference of 1/1/1919 and 1/1/2019 for an example.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-26 11:35:55 +0100

Opaque gravatar image

updated 2019-08-26 11:38:12 +0100


you need to have a template defaulting format Date to your desired format. To do so:

  1. Open an empty spreadsheet
  2. Go to any cell (e.g. cell A1)
  3. Right click and select Format Cells... from the context dialog
  4. Select Date in Category and your desired format in Format (e.g. 12/31/1999 = MM/DD/YYYY)
  5. Click button OK
  6. Select File -> Templates -> Save as Template
  7. Provide a Template Name (e.g. "MyCalcTemplate")
  8. Select a Template Category (e.g. "My Templates")
  9. Tick option Set as default template (The important step)
  10. Click button Save
  11. Close your file
  12. Open a new spreadsheet and check your new default working

Procedure tested using:

Version:, Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US,Calc: threaded

If the answer is correct or helped you to fix your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-26 07:37:59 +0100

Seen: 48 times

Last updated: Aug 26