Ask Your Question

How Do I Change Date Format From American to European

asked 2017-07-19 09:59:44 +0200

bikermanirl gravatar image

I have a spreadsheet with American date format. If I try to change the Date to European format it shows 10/4/2016 (american format) as 10th April instead of 4th October.

How do I convert the dates?

edit retag flag offensive close merge delete


Quoting @bikermanirl: "If I try to change the Date to European format..."

How did you try?
Did you assume the date found to be a number? ... to be text?
Did you decide this in any way? How?
What UI-language set for your install of LibO?
What locale chosen under 'Tools' > 'Options' 'Language Settings' > 'Languages' ?

Lupp gravatar imageLupp ( 2017-07-19 10:47:43 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-07-19 10:10:53 +0200

gabix gravatar image

Try this: in the cell format dialog, change the language on the Numbers tab to a European language, except for English(UK).

edit flag offensive delete link more


+1, but why except for English (UK) ?

librebel gravatar imagelibrebel ( 2017-07-20 15:14:33 +0200 )edit

Try it and see :) Changing the language changes only the presentation, so, you won't loose anything.

gabix gravatar imagegabix ( 2017-07-20 21:58:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-19 09:59:44 +0200

Seen: 1,533 times

Last updated: Jul 19 '17