\<bookmark_value\>currency formats; spreadsheets\</bookmark_value\>\<bookmark_value\>cells; currency formats\</bookmark_value\>\<bookmark_value\>international currency formats\</bookmark_value\>\<bookmark_value\>formats; currency formats in cells\</bookmark_value\>\<bookmark_value\>currencies; default currencies\</bookmark_value\>\<bookmark_value\>defaults;currency formats\</bookmark_value\>\<bookmark_value\>changing;currency formats\</bookmark_value\>

Cells in Currency Format

In LibreOffice Calc you can give numbers any currency format. When you click the Currency icon Icon in the Formatting bar to format a number, the cell is given the default currency format set under - Language Settings - Languages.

Note Icon

Exchanging of \<item type=\"productname\"\>LibreOffice\</item\> Calc documents can lead to misunderstandings, if your \<item type=\"productname\"\>LibreOffice\</item\> Calc document is loaded by a user who uses a different default currency format.


In \<item type=\"productname\"\>LibreOffice\</item\> Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euro in another country and does not become dollars.

You can change the currency format in the \<emph\>Format Cells\</emph\> dialog (choose \<emph\>Format - Cells - Numbers\</emph\> tab) by two country settings. In the \<emph\>Language\</emph\> combo box select the basic setting for currency symbol, decimal and thousands separators. In the \<emph\>Format\</emph\> list box you can select possible variations from the default format for the language.

  1. For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the \<emph\>Format\</emph\> list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting.

  2. If, under \<emph\>Language\</emph\>, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00".