1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2fee07e66Smseidel 3ce44d6c1SAndrew Rist<!--*********************************************************** 4fee07e66Smseidel * 5ce44d6c1SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 6ce44d6c1SAndrew Rist * or more contributor license agreements. See the NOTICE file 7ce44d6c1SAndrew Rist * distributed with this work for additional information 8ce44d6c1SAndrew Rist * regarding copyright ownership. The ASF licenses this file 9ce44d6c1SAndrew Rist * to you under the Apache License, Version 2.0 (the 10ce44d6c1SAndrew Rist * "License"); you may not use this file except in compliance 11ce44d6c1SAndrew Rist * with the License. You may obtain a copy of the License at 12fee07e66Smseidel * 13ce44d6c1SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14fee07e66Smseidel * 15ce44d6c1SAndrew Rist * Unless required by applicable law or agreed to in writing, 16ce44d6c1SAndrew Rist * software distributed under the License is distributed on an 17ce44d6c1SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18ce44d6c1SAndrew Rist * KIND, either express or implied. See the License for the 19ce44d6c1SAndrew Rist * specific language governing permissions and limitations 20ce44d6c1SAndrew Rist * under the License. 21fee07e66Smseidel * 22ce44d6c1SAndrew Rist ***********************************************************--> 23ce44d6c1SAndrew Rist 24*72c4b3b3Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalcguidecurrency_formatxml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Cells in Currency Format</title> 28cdf0e10cSrcweir<filename>/text/scalc/guide/currency_format.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32*72c4b3b3Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3156329"> 33*72c4b3b3Smseidel<bookmark_value>currency formats; spreadsheets</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>cells; currency formats</bookmark_value> 35cdf0e10cSrcweir<bookmark_value>international currency formats</bookmark_value> 36cdf0e10cSrcweir<bookmark_value>formats; currency formats in cells</bookmark_value> 37cdf0e10cSrcweir<bookmark_value>currencies; default currencies</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>defaults;currency formats</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>changing;currency formats</bookmark_value> 40cdf0e10cSrcweir</bookmark><comment>mw changed one index entry</comment> 41cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3156329" role="heading" level="1" l10n="U" 42cdf0e10cSrcweiroldref="46"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link> 43cdf0e10cSrcweir</variable></paragraph> 44fee07e66Smseidel<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 45cdf0e10cSrcweir<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> 46cdf0e10cSrcweir</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> 47cdf0e10cSrcweir<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> 48cdf0e10cSrcweir<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> 49cdf0e10cSrcweir<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> 50cdf0e10cSrcweir<list type="ordered"> 51cdf0e10cSrcweir<listitem> 52fee07e66Smseidel<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> 53cdf0e10cSrcweir</listitem> 54cdf0e10cSrcweir<listitem> 55cdf0e10cSrcweir<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> 56cdf0e10cSrcweir</listitem> 57cdf0e10cSrcweir</list> 58cdf0e10cSrcweir<section id="relatedtopics"> 59cdf0e10cSrcweir<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 60cdf0e10cSrcweir<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> 61cdf0e10cSrcweir</section> 62cdf0e10cSrcweir</body> 63fee07e66Smseidel</helpdocument> 64
