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

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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? – w3dk Nov 2 '13 at 11:17

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.