Ask Your Question

Is there a toolbar button to add thousands separator? [closed]

asked 2014-05-27 15:31:34 +0200

slamet gravatar image

updated 2015-09-05 23:53:16 +0200

Alex Kemp gravatar image

I am using LibreOffice on Ubuntu 14.04, and I am searching for a toolbar button that adds thousands separator in Calc but I cannot find it. The closest thing I can find is Currency button, but that is not what I want. I usually work with a lot of numbers and do not need currency symbol such as $ or in my case Rp/IDR. Of course I can format those numbers via Format --> Cells --> Numbers, but doing that all the time is too much work for a simple thing. I mean Office has this "," button and gnumeric has this "." button, why can't we have similar button in LibreOffice?

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 2016-02-23 21:31:28.845813

2 Answers

Sort by » oldest newest most voted

answered 2014-05-27 19:03:30 +0200

Lupp gravatar image

If you prefer having a clickable icon: There is a command 'Number Format : Decimal' from the 'Category' 'Format' which is already connected to an icon you may ADD to your 'Formatting' toolbar, e.g. It does exactly work the same way as the shortcut karolus mentioned.

See image image description

edit flag offensive delete link more


Thanks a lot, I didn't know that I need to push ADD button first and find Format in Category Listbox and then find the Number Format: Decimal in Command Listbox. My life is easier now.

slamet gravatar imageslamet ( 2014-05-28 16:53:49 +0200 )edit

However, this is not the same as "thousand seperator"... this convert number into "0.00" while thousand seperator simply add "," between thousands (such as 56,000)

Ljiljan gravatar imageLjiljan ( 2014-11-17 20:46:34 +0200 )edit

You are right - and I am upset a bit. It shouldn't be habit to read that superficially. However, thousand separators are not used much (imo) except with formats containing a currency. Such a format, including the thousands separator and the currency symbol according to your settind you can choose by clicking the coins icon in the formatting toolbar, by default left of the "%" icon. I dont know another formatting icon in this context.

Lupp gravatar imageLupp ( 2014-11-17 21:24:44 +0200 )edit

Juist another hint. The thousands separators offered dependen on the locale or not in accordance with ISO standards.

Lupp gravatar imageLupp ( 2014-11-17 21:26:37 +0200 )edit

Your answered helped me too :) However, the thousand separator is something I would like to have as well :)

Ljiljan gravatar imageLjiljan ( 2014-12-06 16:43:43 +0200 )edit

You might consider the following: Using the comma or the dot as a "thousands separator" depending on the decimal seperator used by the respective locale will intensify the danger of misunderstandings in international exchange. I never use it. The only international standard I know touching the matter is ISO 31. It tells us: Numbers consisting of long sequences of digits can be made more readable by separating them into groups, preferably groups of three, separated by a small space.

Lupp gravatar imageLupp ( 2014-12-06 17:41:06 +0200 )edit

Question Tools

1 follower


Asked: 2014-05-27 15:31:34 +0200

Seen: 2,419 times

Last updated: May 27 '14