Ask Your Question
0

LibreOffice Calc Thousands Separators?

asked 2020-08-30 15:38:34 +0100

w0lf gravatar image

I'm new to LibreOffice Calc and can't find a setting to change number format with Decimal and Thousands Separators.

It's easy to do this in Microsoft Excel as there is a dedicated button to change it.

Please let me know how to do this in LibreOffice Calc.

Input: 1234

Desired Output 1: 1,234

Desired Output 2: 1,234.00

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
2

answered 2020-08-30 16:10:32 +0100

Opaque gravatar image

updated 2020-08-30 16:18:11 +0100

Hello,

  • Right click -> Format Cells...->Tab: Numbers
    (or CTRL+1 -> Tab: Numbers or Format -> Cells...-> Tab: Numbers)
  • Select Number under Category
  • Select -1,235 under Format (Format Code shows: #,##0 - Desired Output 1: 1,234)
  • Select -1,234.57 under Format (Format Code shows: #,##0.00 - Desired Output 2: 1,234.00)
  • Click OK

image description

Note(s)

  • Decimal delimiter and thousands separator depend on your locale setting, you may need to set the language of your cell to English(USA) to get the desired result.
  • Desired output 2 can be created using CTRL+SHIFT+1 or by clicking icon labeled 0.0

Hope that helps.

edit flag offensive delete link more
0

answered 2020-08-30 16:25:31 +0100

Zizi64 gravatar image

My Tip: Use the Cell styles instead of the direct (manual) formatting method. You can use same properties in a Custom cell style, what you can apply directly to the selected cells.

edit flag offensive delete link more

Comments

Valuable hint, but how does that answer the question to change the thousand separator?

Vanadium gravatar imageVanadium ( 2020-08-30 17:56:06 +0100 )edit

When you apply a well adjusted cell style, then the number formats in the formatted cells will be modified to the desired format. The Cell style will contain the format code and all of other relevant/available properties, like the language, etc...

Zizi64 gravatar imageZizi64 ( 2020-08-30 18:01:37 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-30 15:38:34 +0100

Seen: 130 times

Last updated: Aug 30 '20