Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a column with date values with initial value as: '01.02.13' (in format DD.MM.YY) . Converted it to the required format (DD.MM.YYYY) '01.02.2013'. But when I focus on the cell it shows date as '02/01/2013' . How to change this value so that it shows in the desired format on focus as well.

share|improve this question

migrated from Apr 30 '13 at 12:06

This question came from our site for professional and enthusiast programmers.

This looks as if the locale/language might not be set to the desired locale? – w3d Nov 2 '13 at 11:17

1 Answer 1

Mark the column and klick "Format | Cells" choosing one of the possible Date formats which will be presented in the opening menu. (Libr Office Calc 3.5.x)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.