1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir 5*cdf0e10cSrcweir<!-- 6*cdf0e10cSrcweir *********************************************************************** 7*cdf0e10cSrcweir * 8*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9*cdf0e10cSrcweir * 10*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 11*cdf0e10cSrcweir * 12*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 13*cdf0e10cSrcweir * 14*cdf0e10cSrcweir * This file is part of OpenOffice.org. 15*cdf0e10cSrcweir * 16*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 17*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 18*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 19*cdf0e10cSrcweir * 20*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 21*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 22*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 24*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 27*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 28*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 29*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 30*cdf0e10cSrcweir * 31*cdf0e10cSrcweir ************************************************************************ 32*cdf0e10cSrcweir --> 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir <helpdocument version="1.0"> 36*cdf0e10cSrcweir<meta> 37*cdf0e10cSrcweir<topic id="textshared0105020300xml" indexer="include" status="PUBLISH"> 38*cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Numbers / Format</title> 39*cdf0e10cSrcweir<filename>/text/shared/01/05020300.xhp</filename> 40*cdf0e10cSrcweir</topic> 41*cdf0e10cSrcweir</meta> 42*cdf0e10cSrcweir<body> 43*cdf0e10cSrcweir 44*cdf0e10cSrcweir 45*cdf0e10cSrcweir 46*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3152942"><bookmark_value>formats; number and currency formats</bookmark_value> 47*cdf0e10cSrcweir<bookmark_value>number formats; formats</bookmark_value> 48*cdf0e10cSrcweir<bookmark_value>currencies;format codes</bookmark_value> 49*cdf0e10cSrcweir<bookmark_value>defaults; number formats</bookmark_value> 50*cdf0e10cSrcweir</bookmark> 51*cdf0e10cSrcweir <comment>mw transferred "format codes;" to Calc guide Format_value_userdef.xhp and "numers;" and "cells;" to Calc guide Format_table.xhp. Changed "currencies;"</comment> 52*cdf0e10cSrcweir 53*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CUI_HID_NUMBERFORMAT" id="bm_id3150146" localize="false"/> 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:TableNumberFormatDialog" id="bm_id2370759" localize="false"/> 56*cdf0e10cSrcweir 57*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:TableNumberFormatDialog" id="bm_id3148731" localize="false"/> 58*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3152942" role="heading" level="1" l10n="U" oldref="1">Numbers / Format</paragraph> 59*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145071" role="paragraph" l10n="U" oldref="2"><variable id="zahlen"><ahelp hid=".uno:TableNumberFormatDialog">Specify the formatting options for the selected cell(s).</ahelp> 60*cdf0e10cSrcweir</variable></paragraph> 61*cdf0e10cSrcweir<section id="howtoget"> 62*cdf0e10cSrcweir <embed href="text/shared/00/00040503.xhp#zahlen"/> 63*cdf0e10cSrcweir</section> 64*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:ListBox:RID_SVXPAGE_NUMBERFORMAT:LB_CATEGORY" id="bm_id3153312" localize="false"/> 65*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155392" role="heading" level="2" l10n="U" oldref="3">Category</paragraph> 66*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150774" role="paragraph" l10n="U" oldref="4"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CATEGORY">Select a category from the list, and then select a formatting style in the <emph>Format </emph>box.</ahelp></paragraph> 67*cdf0e10cSrcweir 68*cdf0e10cSrcweir<switch select="appl"> 69*cdf0e10cSrcweir 70*cdf0e10cSrcweir<case select="CALC"> 71*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145416" role="note" l10n="U" oldref="101">The default currency format for a cell is determined by the regional settings of your operating system.</paragraph> 72*cdf0e10cSrcweir 73*cdf0e10cSrcweir</case> 74*cdf0e10cSrcweir 75*cdf0e10cSrcweir</switch> 76*cdf0e10cSrcweir 77*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CUI_HID_NUMBERFORMAT_LB_FORMAT" id="bm_id3155449" localize="false"/> 78*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155342" role="heading" level="2" l10n="U" oldref="5">Format</paragraph> 79*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148491" role="paragraph" l10n="U" oldref="6"><ahelp hid="HID_NUMBERFORMAT_LB_FORMAT">Select how you want the contents of the selected cell(s) to be displayed.</ahelp> The code for the selected option is displayed in the <emph>Format Code</emph> box.</paragraph> 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:ListBox:RID_SVXPAGE_NUMBERFORMAT:LB_CURRENCY" id="bm_id3154381" localize="false"/> 82*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154811" role="heading" level="3" l10n="U" oldref="97">Currency category list boxes</paragraph> 83*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148563" role="paragraph" l10n="U" oldref="98"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_CURRENCY">Select a currency, and then scroll to the top of the <emph>Format</emph> list to view the formatting options for the currency.</ahelp></paragraph> 84*cdf0e10cSrcweir <section id="waehrungtext"> 85*cdf0e10cSrcweir 86*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150866" role="note" l10n="U" oldref="99">The format code for currencies uses the form [$xxx-nnn], where xxx is the currency symbol, and nnn the country code. Special banking symbols, such as EUR (for Euro), do not require the country code. The currency format is not dependent on the language that you select in the<emph> Language</emph> box. </paragraph> 87*cdf0e10cSrcweir 88*cdf0e10cSrcweir </section> 89*cdf0e10cSrcweir 90*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:ListBox:RID_SVXPAGE_NUMBERFORMAT:LB_LANGUAGE" id="bm_id3148797" localize="false"/> 91*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154071" role="heading" level="2" l10n="U" oldref="23">Language</paragraph> 92*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154138" role="paragraph" l10n="U" oldref="24"><ahelp hid="SVX:LISTBOX:RID_SVXPAGE_NUMBERFORMAT:LB_LANGUAGE">Specifies the language setting for the selected <switchinline select="appl"><caseinline select="CALC">cells 93*cdf0e10cSrcweir</caseinline><defaultinline>fields</defaultinline></switchinline>. With the language set to <emph>Automatic</emph>, $[officename] automatically applies the number formats associated with the system default language. Select any language to fix the settings for the selected <switchinline select="appl"><caseinline select="CALC">cells 94*cdf0e10cSrcweir</caseinline><defaultinline>fields</defaultinline></switchinline>.</ahelp></paragraph> 95*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3157320" role="paragraph" l10n="U" oldref="102">The language setting ensures that date and currency formats are preserved even when the document is opened in an operating system that uses a different default language setting.</paragraph> 96*cdf0e10cSrcweir 97*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:CheckBox:RID_SVXPAGE_NUMBERFORMAT:CB_SOURCEFORMAT" id="bm_id3145747" localize="false"/> 98*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155995" role="heading" level="2" l10n="U" oldref="104">Source format</paragraph> 99*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3144432" role="paragraph" l10n="U" oldref="105"><ahelp hid="SVX_CHECKBOX_RID_SVXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT">Uses the same number format as the cells containing the data for the chart.</ahelp></paragraph> 100*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3148451" role="heading" level="2" l10n="U" oldref="7">Options</paragraph> 101*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148922" role="paragraph" l10n="U" oldref="8">Specify the options for the selected format.</paragraph> 102*cdf0e10cSrcweir 103*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:NumericField:RID_SVXPAGE_NUMBERFORMAT:ED_DECIMALS" id="bm_id3151178" localize="false"/> 104*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153970" role="heading" level="3" l10n="U" oldref="9">Decimal places</paragraph> 105*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154684" role="paragraph" l10n="U" oldref="10"><ahelp hid="SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_DECIMALS">Enter the number of decimal places that you want to display.</ahelp></paragraph> 106*cdf0e10cSrcweir 107*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:NumericField:RID_SVXPAGE_NUMBERFORMAT:ED_LEADZEROES" id="bm_id3153106" localize="false"/> 108*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154819" role="heading" level="3" l10n="U" oldref="11">Leading zeroes</paragraph> 109*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147352" role="paragraph" l10n="CHG" oldref="12"><ahelp hid="SVX:NUMERICFIELD:RID_SVXPAGE_NUMBERFORMAT:ED_LEADZEROES">Enter the maximum number of zeroes to display in front of the decimal point.</ahelp></paragraph> 110*cdf0e10cSrcweir 111*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:CheckBox:RID_SVXPAGE_NUMBERFORMAT:BTN_NEGRED" id="bm_id3157895" localize="false"/> 112*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155131" role="heading" level="3" l10n="U" oldref="13">Negative numbers in red</paragraph> 113*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159252" role="paragraph" l10n="U" oldref="14"><ahelp hid="SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_NEGRED">Changes the font color of negative numbers to red.</ahelp></paragraph> 114*cdf0e10cSrcweir 115*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:CheckBox:RID_SVXPAGE_NUMBERFORMAT:BTN_THOUSAND" id="bm_id3148645" localize="false"/> 116*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="3" l10n="U" oldref="15">Use thousands separator</paragraph> 117*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146148" role="paragraph" l10n="U" oldref="16"><ahelp hid="SVX:CHECKBOX:RID_SVXPAGE_NUMBERFORMAT:BTN_THOUSAND">Inserts a separator between thousands. The type of separator that is used depends on your language settings.</ahelp></paragraph> 118*cdf0e10cSrcweir 119*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:Edit:RID_SVXPAGE_NUMBERFORMAT:ED_FORMAT" id="bm_id3150961" localize="false"/> 120*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150103" role="heading" level="2" l10n="U" oldref="17">Format code</paragraph> 121*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph" l10n="U" oldref="18"><ahelp hid="SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_FORMAT">Displays the number format code for the selected format. You can also enter a custom format.</ahelp> The following options are only available for user-defined number formats.</paragraph> 122*cdf0e10cSrcweir 123*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CUI_HID_NUMBERFORMAT_TBI_ADD" id="bm_id3163717" localize="false"/> 124*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155311" role="heading" level="3" l10n="U" oldref="19">Add</paragraph> 125*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147219" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_NUMBERFORMAT_TBI_ADD">Adds the number format code that you entered to the user-defined category.</ahelp></paragraph> 126*cdf0e10cSrcweir 127*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CUI_HID_NUMBERFORMAT_TBI_REMOVE" id="bm_id3159181" localize="false"/> 128*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="3" l10n="U" oldref="21">Delete</paragraph> 129*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154150" role="paragraph" l10n="U" oldref="22"><ahelp hid="HID_NUMBERFORMAT_TBI_REMOVE">Deletes the selected number format.</ahelp> The changes are effective after you restart $[officename].</paragraph> 130*cdf0e10cSrcweir 131*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/CUI_HID_NUMBERFORMAT_TBI_INFO" id="bm_id3151119" localize="false"/> 132*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153573" role="heading" level="3" l10n="U" oldref="26">Edit Comment</paragraph> 133*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3083444" role="paragraph" l10n="U" oldref="27"><ahelp hid="HID_NUMBERFORMAT_TBI_INFO">Adds a comment to the selected number format.</ahelp>.</paragraph> 134*cdf0e10cSrcweir 135*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui:Edit:RID_SVXPAGE_NUMBERFORMAT:ED_COMMENT" id="bm_id3154470" localize="false"/> 136*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150332" role="heading" level="3" l10n="U" oldref="95">Name line</paragraph> 137*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156060" role="paragraph" l10n="U" oldref="96"><ahelp hid="SVX:EDIT:RID_SVXPAGE_NUMBERFORMAT:ED_COMMENT">Enter a comment for the selected number format, and then click outside this box.</ahelp></paragraph> 138*cdf0e10cSrcweir <embed href="text/shared/00/00000001.xhp#vorschau"/> 139*cdf0e10cSrcweir <section id="relatedtopics"> 140*cdf0e10cSrcweir 141*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145364" role="paragraph" l10n="C"><link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link></paragraph> 142*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153095" role="paragraph" l10n="C"><link href="text/shared/01/05020301.xhp" name="Custom format codes">Custom format codes</link></paragraph> 143*cdf0e10cSrcweir 144*cdf0e10cSrcweir </section> 145*cdf0e10cSrcweir </body> 146*cdf0e10cSrcweir</helpdocument> 147