Ask Your Question
0

Calc: Customize 'General' number format

asked 2018-03-06 13:34:58 +0200

macdjord gravatar image

Is there any way I can adjust the behaviour of the default 'General' number format in LibreOffice Calc? In particular, I'd like to set it to use thousands separators.

I know how to customize the format of any particular cell, but:

  • This requires me to apply the format manually to the cells in question, instead of having it just work like I want it to by default
  • The General format does a lot of things automatically - real numbers are displayed with the right number of decimal places, integers are displayed with no decimal sign at all, if I type in a number as a percentage or dollar amount it automatically gets formatted correctly - which I lose if I apply a specific number format to a cell
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-06 23:02:51 +0200

Jim K gravatar image

Modify the Default style in the Styles and Formatting sidebar. Changes apply throughout the current spreadsheet. To change all new spreadsheets as well, modify the default template.

...real numbers are displayed with the right number of decimal places.

A limited number of decimal places can be set at Tools -> Options -> LibreOffice Calc -> Calculate -> Limit decimals for general number format.

...if I type in a number as a percentage or dollar amount it automatically gets formatted correctly.

This behavior depends on settings at Tools -> Options -> Language Settings -> Languages.

edit flag offensive delete link more

Comments

Using the Styles and Formatting sidebar, I am able to change the default number format from 'General' to a specific format code of my choosing, but that's not what I'm asking. What I'm trying to do is _change the behaviour of the 'General' format_. The 'General' format does various magic things that, as far as I can tell, cannot be done with other format codes. I want to keep that magic, while also having thousands separators.

macdjord gravatar imagemacdjord ( 2018-03-07 20:13:00 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-06 13:34:58 +0200

Seen: 904 times

Last updated: Mar 06 '18