1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski<topic id="textscalcguidecurrency_formatxml" indexer="include" status="PUBLISH"> 30*b1cdbd2cSJim Jagielski<title xml-lang="en-US" id="tit">Cells in Currency Format</title> 31*b1cdbd2cSJim Jagielski<filename>/text/scalc/guide/currency_format.xhp</filename> 32*b1cdbd2cSJim Jagielski</topic> 33*b1cdbd2cSJim Jagielski</meta> 34*b1cdbd2cSJim Jagielski<body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>currency formats; spreadsheets</bookmark_value> 36*b1cdbd2cSJim Jagielski<bookmark_value>cells; currency formats</bookmark_value> 37*b1cdbd2cSJim Jagielski<bookmark_value>international currency formats</bookmark_value> 38*b1cdbd2cSJim Jagielski<bookmark_value>formats; currency formats in cells</bookmark_value> 39*b1cdbd2cSJim Jagielski<bookmark_value>currencies; default currencies</bookmark_value> 40*b1cdbd2cSJim Jagielski<bookmark_value>defaults;currency formats</bookmark_value> 41*b1cdbd2cSJim Jagielski<bookmark_value>changing;currency formats</bookmark_value> 42*b1cdbd2cSJim Jagielski</bookmark><comment>mw changed one index entry</comment> 43*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3156329" role="heading" level="1" l10n="U" 44*b1cdbd2cSJim Jagielskioldref="46"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link> 45*b1cdbd2cSJim Jagielski</variable></paragraph> 46*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3153968" role="paragraph" l10n="CHG" oldref="47">In <item type="productname">%PRODUCTNAME</item> Calc you can give numbers any currency format. When you click the <item type="menuitem">Currency</item> icon 47*b1cdbd2cSJim Jagielski<image id="img_id3150791" src="res/commandimagelist/sc_currencyfield.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3150791">Icon</alt> 48*b1cdbd2cSJim Jagielski</image> in the <item type="menuitem">Formatting</item> bar to format a number, the cell is given the default currency format set under <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Language Settings - Languages</item>.</paragraph> 49*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3150010" role="note" l10n="CHG" oldref="48">Exchanging of <item type="productname">%PRODUCTNAME</item> Calc documents can lead to misunderstandings, if your <item type="productname">%PRODUCTNAME</item> Calc document is loaded by a user who uses a different default currency format.</paragraph> 50*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="52">In <item type="productname">%PRODUCTNAME</item> Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euros in another country and does not become dollars.</paragraph> 51*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3151075" role="paragraph" l10n="CHG" oldref="49">You can change the currency format in the <item type="menuitem">Format Cells</item> dialog (choose <item type="menuitem">Format - Cells - Numbers</item> tab) by two country settings. In the <item type="menuitem">Language</item> combo box select the basic setting for decimal and thousands separators. In the <item type="menuitem">Format</item> list box you can select the currency symbol and its position.</paragraph> 52*b1cdbd2cSJim Jagielski<list type="ordered"> 53*b1cdbd2cSJim Jagielski<listitem> 54*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3150749" role="listitem" l10n="U" oldref="50">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 <item type="menuitem">Format</item> 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.</paragraph> 55*b1cdbd2cSJim Jagielski</listitem> 56*b1cdbd2cSJim Jagielski<listitem> 57*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3145640" role="listitem" l10n="U" oldref="51">If, under <item type="menuitem">Language</item>, 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".</paragraph> 58*b1cdbd2cSJim Jagielski</listitem> 59*b1cdbd2cSJim Jagielski</list> 60*b1cdbd2cSJim Jagielski<section id="relatedtopics"> 61*b1cdbd2cSJim Jagielski<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 62*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="53"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> 63*b1cdbd2cSJim Jagielski</section> 64*b1cdbd2cSJim Jagielski</body> 65*b1cdbd2cSJim Jagielski</helpdocument>
