[Solved] Set decimal comma rather than decimal point?

[Julius Techlover]

Please!! I need somebody help me, I use the comma as decimal separator, but in can't find the way to set this in Open Office, even though I have set decimal comma as default in my system. I have the 2.4 version. Thanks. This software is very nice, but I need it have decimal comma!!!

Julius

Thank you very much friends, your help was so useful. Just, the only way I could do this was selecting Spanish of Spain as local setting, even though I actually live in Guatemala... but, That really no matter, the case is I solved my troubleshotting. Thank you very much!!!

[Sjoerd]

I think it is done by checking the box 'Decimal seperator key'. You find it in Tools - Options - Language Settings - Languages.

[Hagar Delest]

Does it help (opposite question so you should adapt): [Solved] How to use . for decimals?

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

[Villeroy]

Set the numeric locale accordingly on cell, document or application level as described in http://user.services.openoffice.org/en/ ... 773#p47773
The "decimal separator key" in the options adjusts the decimal key on the numeric pad of your keyboard to dot or comma according to the previous set locale.

[Hagar Delest]

You can set the locale for numbers ...
... on cell level: Format>Cells...tab:Numbers (using hard formatting or any userdefined style for that purpose)
... for all cells in this document: number format locale of style "Default" (mother of cell-styles) with any exception you may have defined in userdefined styles.
... for the entire office suite: Tools>Options...Language Settings>Languages, "Locale setting"

I would put that in the opposite order to highlight the fact that the general setting (Tools>Options>...) is overridden by the cell style, which is also overridden by a direct formating (Format>Cells>...).

[Villeroy]

I would put that in the opposite order to highlight the fact that the general setting (Tools>Options>...) is overridden by the cell style, which is also overridden by a direct formating (Format>Cells>...).

So true! Done.