Ask Your Question

Can't change (list) {decimal} separator

asked 2018-03-13 13:18:41 +0200

Loufas gravatar image

updated 2018-03-13 15:24:14 +0200

Lupp gravatar image

So I've seen in forums you have to format cells to change decimal symbol. So the default is . and i tried to make it , . Pressed OK of course, tried to switch system decimal symbol and the error is still there even after saving, restarting libre office etc. What do I do wrong?

image description

edit retag flag offensive close merge delete


Answer depends heavily on OS. Which is yours? What's your locale? Also LO version may be useful.

ajlittoz gravatar imageajlittoz ( 2018-03-13 13:55:47 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-13 14:07:10 +0200

Mike Kaganski gravatar image

You have selected an explicit language for your cell (Greek). That makes the decimal separator to be what is hardcoded in LO for that locale. You should either select another language that uses the separator you need (e.g., French), of use Default-XXX (which means that the locale settings would be defined by higher-level settings, possibly OS).

edit flag offensive delete link more

answered 2018-03-13 19:24:21 +0200

Gilward Kukel gravatar image

In "Tools - Options - Language Settings - Languages" set Locale setting to Greek. Then you will have to correct the formula, I think.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-13 13:18:41 +0200

Seen: 28 times

Last updated: Mar 13