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