We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Decimal and thousands separators in numbers and how locales apply to this? [closed]

asked 2018-10-30 08:58:51 +0200

damdim gravatar image

updated 2021-05-27 16:08:16 +0200

Alex Kemp gravatar image

Hi, I have installed libreoffice 6.1.2 on Windows 10. My language is set to Greek so the decimal separator key is "," When I type or paste 0.5 0.05 0.0005 it stays as what I typed, align left as text. But when I type 0.005 then it converts to 5 and aligns right as number. The same thing happens when I change the locale to English, but with the text 0,5 0,05 0,005 etc. Is this a bug or intended behavior?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-27 16:08:34.444558


+1 for saying what your version and OS are.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-30 18:37:10 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-10-30 09:06:31 +0200

In Greek locale, the dot is also used in numbers - as thousand separator. So, when you have the proper three digits after the ., it is recognized that you've entered the proper number (zero thousand and five), and it's treated as such. The same holds for English locale (modulo using , for thousand separator).

If you need your input to always be considered text, then just format your cells (columns?) as text prior to input.

edit flag offensive delete link more



Either that, or input otherwise numeric values with a leading apostrophe '0.005 which forces content to Text type; the apostrophe will not be part of the cell content.

erAck gravatar imageerAck ( 2018-10-30 11:54:09 +0200 )edit

answered 2018-10-30 09:38:09 +0200

damdim gravatar image

Spot on. Thank you.

edit flag offensive delete link more


@damdim, the appropriate place to put your thank you is first to check the up arrow above the Zero '0' to the left of the answer you received. ALSO, if this answered your question (the one that you typed in above), the proper thing to do is the click on the check mark below this zero, to turn it green. This lets everyone know that your question has been answered. It also rewards the person who answered your question with points, and as you yourself get more points here you will get respect.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-30 18:32:57 +0200 )edit

Question Tools

1 follower


Asked: 2018-10-30 08:58:51 +0200

Seen: 577 times

Last updated: Oct 30 '18