1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: currency_format.xhp,v $
* $Revision: 1.9 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalcguidecurrency_formatxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Cells in Currency Format</title>
<filename>/text/scalc/guide/currency_format.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2006-02-13T15:06:10">FPE: cleaned up, deleted screenshot</lastedited>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><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>
</bookmark><comment>mw changed one index entry</comment>
<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1" l10n="U" oldref="46"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3153968" xml-lang="en-US" l10n="CHG" oldref="47">In <item type="productname">%PRODUCTNAME</item> Calc you can give numbers any currency format. When you click the <emph>Currency</emph> icon
<image id="img_id3150791" src="res/commandimagelist/sc_currencyfield.png" width="4.23mm" height="4.23mm"><alt id="alt_id3150791" xml-lang="en-US">Icon</alt>
</image> in the <emph>Formatting </emph>bar to format a number, the cell is given the default currency format set under <item type="menuitem">Tools - Options - Language Settings - Languages</item>.</paragraph>
<paragraph role="note" id="par_id3150010" xml-lang="en-US" 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>
<paragraph role="paragraph" id="par_id3156442" xml-lang="en-US" 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>
<paragraph role="paragraph" id="par_id3151075" xml-lang="en-US" l10n="U" oldref="49">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.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" 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 <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.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3145640" xml-lang="en-US" l10n="U" oldref="51">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".</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
<paragraph role="paragraph" id="par_id3154255" xml-lang="en-US" l10n="U" oldref="53"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link></paragraph>
</section>
</body>
</helpdocument>
|
