Ask Your Question

How do I get LibreOffice to display dates as YY.MM.DD instead of MM/DD/YY? [closed]

asked 2018-08-12 20:16:05 +0200

MicrosoftEscapee gravatar image

I am using Mac OS 10.9.5 on an iMac27 (late 2013) with my profile already set to display dates as YY.MM.DD. A spreadsheet imported from Excel that had dates entered as YY.MM.DD was converted to MM/DD/YY when opened in Calc. I can't find the tool to change the display format.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by MicrosoftEscapee
close date 2018-08-13 20:52:19.319276

3 Answers

Sort by » oldest newest most voted

answered 2018-08-12 20:48:05 +0200

JBF gravatar image

Menu Format > Cell > Number tab

edit flag offensive delete link more

answered 2018-08-12 20:55:01 +0200

Lupp gravatar image

In addition: Consider to always show (and use) 4-digit-year.
Imternationally standardised date format (ISO 8601) you get with the code YYYY-MM-DD (in English locales at least).

edit flag offensive delete link more

answered 2018-08-13 20:51:18 +0200

MicrosoftEscapee gravatar image

Thank you! I kept trying to do it through Menu>Format>Number Format>Date. I did have to customize the / to . get exactly what I wanted.

So far I like this package a lot.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-08-12 20:16:05 +0200

Seen: 268 times

Last updated: Aug 13 '18