diff options
| author | Kurt Zenker <kz@openoffice.org> | 2009-12-07 14:49:45 +0100 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2009-12-07 14:49:45 +0100 |
| commit | decca1502542de492ebfa996ade68d9f3b3a048f (patch) | |
| tree | ecf115c7238fd9b300213b753a19946f5ed4a26c | |
| parent | b726ccd054f39e97310346fc8acd10c2e57f1f53 (diff) | |
masterfix: #i10000# fixed conflict resolutionooo/DEV300_m67
| -rw-r--r-- | helpcontent2/source/text/shared/01/05020301.xhp | 1555 |
1 files changed, 472 insertions, 1083 deletions
diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp index 36514b4edd..5aa4c4c003 100644 --- a/helpcontent2/source/text/shared/01/05020301.xhp +++ b/helpcontent2/source/text/shared/01/05020301.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.12 $ + * $RCSfile: 05020301.xhp,v $ + * $Revision: 1.13.4.1 $ * * This file is part of OpenOffice.org. * @@ -35,727 +35,120 @@ <meta> - <topic id="textshared0105020301xml" indexer="include"> - <title xml-lang="en-US" id="tit">Number Format Codes</title> - <filename>/text/shared/01/05020301.xhp</filename> - </topic> - </meta> - <body> +<topic id="textshared0105020301xml" indexer="include"> +<title id="tit" xml-lang="en-US">Number Format Codes</title> +<filename>/text/shared/01/05020301.xhp</filename> +</topic> +</meta> +<body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153514"><bookmark_value>format codes; numbers</bookmark_value> - <bookmark_value>conditions; in number formats</bookmark_value> - <bookmark_value>number formats; codes</bookmark_value> - <bookmark_value>currency formats</bookmark_value> - <bookmark_value>formats;of currencies/date/time</bookmark_value> - <bookmark_value>numbers; date, time and currency formats</bookmark_value> - <bookmark_value>Euro; currency formats</bookmark_value> - <bookmark_value>date formats</bookmark_value> - <bookmark_value>times;formats</bookmark_value> -</bookmark><comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment><comment>mw corrected a typo in "times, formats"</comment> -<paragraph xml-lang="en-US" id="hd_id3153514" role="heading" level="1" l10n="U" oldref="1"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> +<bookmark_value>conditions; in number formats</bookmark_value> +<bookmark_value>number formats; codes</bookmark_value> +<bookmark_value>currency formats</bookmark_value> +<bookmark_value>formats;of currencies/date/time</bookmark_value> +<bookmark_value>numbers; date, time and currency formats</bookmark_value> +<bookmark_value>Euro; currency formats</bookmark_value> +<bookmark_value>date formats</bookmark_value> +<bookmark_value>times, formats</bookmark_value> +</bookmark><comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment> +<paragraph role="heading" id="hd_id3153514" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3150467" role="paragraph" l10n="U" oldref="88">Number format codes can consist of up to three sections separated by a semicolon (;).</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3150146" role="listitem" l10n="U" oldref="108">In a number format code with two sections, the first section applies to positive values and zero, and the second section applies to negative values.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3158442" role="listitem" l10n="CHG" oldref="109">In a number format code with three sections, the first section applies to positive values, the second section to negative values, and the third section to the value zero.</paragraph> - </listitem> - </list> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3155069" role="listitem" l10n="U" oldref="110">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="hd_id3151262" role="heading" level="2" l10n="U" - oldref="229">Decimal Places and Significant Digits</paragraph> - <paragraph xml-lang="en-US" id="par_id3153624" role="paragraph" l10n="U" oldref="3">Use zero (0) or the number sign (#) as placeholders in your number format code to represent numbers. The (#) only displays significant digits, while the (0) displays zeroes if there are fewer digits in the number than in the number format.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153323" role="paragraph" l10n="U" oldref="107">Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers.</paragraph> - <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph" l10n="U" oldref="4">If a number contains more digits to the right of the decimal delimiter than there are placeholders in the format, the number is rounded accordingly. If a number contains more digits to the left of the decimal delimiter than there are placeholders in the format, the entire number is displayed. Use the following list as a guide for using placeholders when you create a number format code:</paragraph> - <table id="tbl_id3149760"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150902" role="tablehead" l10n="U" oldref="86">Placeholders</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3157896" role="tablehead" l10n="U" oldref="87">Explanation</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152801" role="code" l10n="U" oldref="5">#</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145090" role="tablecontent" l10n="U" oldref="6">Does not display extra zeros.</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147088" role="code" l10n="U" oldref="7">0 (Zero)</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150774" role="tablecontent" l10n="U" oldref="8">Displays extra zeros if the number has less places than zeros in the format.</paragraph> - </tablecell> - </tablerow> - </table> - - <paragraph xml-lang="en-US" id="par_idN1087E" role="heading" level="3" l10n="NEW">Examples</paragraph> - <table id="tbl_id3153577"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149182" role="tablehead" l10n="U" oldref="9">Number Format</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154749" role="tablehead" l10n="U" oldref="10">Format Code</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148538" role="tablecontent" l10n="U" oldref="11">3456.78 as 3456.8</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150355" role="code" l10n="U" oldref="12">####.#</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154142" role="tablecontent" l10n="U" oldref="13">9.9 as 9.900</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159256" role="code" l10n="U" oldref="14">#.000</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147077" role="tablecontent" l10n="U" oldref="15">13 as 13.0 and 1234.567 as 1234.57</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155388" role="code" l10n="U" oldref="16">#.0#</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149578" role="tablecontent" l10n="U" oldref="17">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145315" role="code" l10n="U" oldref="18"># ???/???</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156152" role="tablecontent" l10n="U" oldref="19">.5 as 0.5</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149762" role="code" l10n="U" oldref="20">0.##</paragraph> - </tablecell> - </tablerow> - </table> - - <paragraph xml-lang="en-US" id="hd_id3149276" role="heading" level="3" l10n="U" - oldref="230">Thousands Separator</paragraph> - <paragraph xml-lang="en-US" id="par_id3154380" role="paragraph" l10n="U" oldref="21">Depending on your language setting, you can use a comma or a period as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.</paragraph> - <table id="tbl_id3150244"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154905" role="tablehead" l10n="U" oldref="22">Number Format</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150822" role="tablehead" l10n="U" oldref="23">Format Code</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147264" role="tablecontent" l10n="U" oldref="24">15000 as 15,000</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151223" role="code" l10n="U" oldref="25">#,###</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154935" role="tablecontent" l10n="U" oldref="26">16000 as 16</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153961" role="code" l10n="U" oldref="27">#,</paragraph> - </tablecell> - </tablerow> - </table> - - <paragraph xml-lang="en-US" id="hd_id3154836" role="heading" level="2" l10n="U" - oldref="79">Including Text in Number Format Codes</paragraph> - <paragraph xml-lang="en-US" id="hd_id3150398" role="heading" level="3" l10n="U" - oldref="231">Text and Numbers</paragraph> - <paragraph xml-lang="en-US" id="par_id3154224" role="paragraph" l10n="U" oldref="80">To include text in a number format that is applied to a cell containing numbers, place a double quotation mark (") in front of and behind the text, or a backslash (\) before a single character. For example, enter <emph>#.# "meters"</emph> to display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m".</paragraph> - <paragraph xml-lang="en-US" id="hd_id3148979" role="heading" level="3" l10n="U" - oldref="232">Text and Text</paragraph> - <paragraph xml-lang="en-US" id="par_id3153338" role="paragraph" l10n="U" oldref="82">To include text in a number format that is applied to a cell that might contain text, enclose the text by double quotation marks (" "), and then add an at sign (@). For example, enter <emph>"Total for "@</emph> to display "Total for December".</paragraph> - <paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3" l10n="U" - oldref="233">Spaces</paragraph> - <paragraph xml-lang="en-US" id="par_id3156294" role="paragraph" l10n="U" oldref="81">To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, <emph>_M</emph> creates a wider space than <emph>_i</emph>.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3155994" role="heading" level="2" l10n="U" - oldref="234">Color</paragraph> - <paragraph xml-lang="en-US" id="par_id3156423" role="paragraph" l10n="U" oldref="28">To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]:</paragraph> - <table id="tbl_id3157321"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154630" role="code" l10n="U" oldref="29">CYAN</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148676" role="code" l10n="U" oldref="30">GREEN</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154123" role="code" l10n="U" oldref="31">BLACK</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149167" role="code" l10n="U" oldref="32">BLUE</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3158407" role="code" l10n="U" oldref="33">MAGENTA</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149560" role="code" l10n="U" oldref="34">RED</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147502" role="code" l10n="U" oldref="35">WHITE</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153368" role="code" l10n="U" oldref="36">YELLOW</paragraph> - </tablecell> - </tablerow> - </table> - - <paragraph xml-lang="en-US" id="hd_id3147435" role="heading" level="2" l10n="U" - oldref="111">Conditions</paragraph> - <paragraph xml-lang="en-US" id="hd_id3148575" role="heading" level="3" l10n="U" - oldref="235">Conditional Brackets</paragraph> - <paragraph xml-lang="en-US" id="par_id3155312" role="paragraph" l10n="U" oldref="112">You can define a number format so that it only applies when the condition that you specify is met. Conditions are enclosed by square brackets [ ].</paragraph> - <paragraph xml-lang="en-US" id="par_id3159179" role="paragraph" l10n="U" oldref="115">You can use any combination of numbers and the <, <=, >, >=, = and <> operators.</paragraph> - <paragraph xml-lang="en-US" id="par_id3159196" role="paragraph" l10n="U" oldref="236">For example, if you want to apply different colors to different temperature data, enter:</paragraph> - <paragraph xml-lang="en-US" id="par_id3150872" role="example" l10n="U" oldref="113">[BLUE][<0]#,0 "°C";[RED][>30]#,0 "°C";[BLACK]#,0 "°C"</paragraph> - <paragraph xml-lang="en-US" id="par_id3157870" role="paragraph" l10n="U" oldref="114">All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3154833" role="heading" level="3" l10n="U" - oldref="90">Positive and Negative Numbers</paragraph> - <paragraph xml-lang="en-US" id="par_id3147295" role="paragraph" l10n="U" oldref="91">To define a number format that adds a different text to a number depending on if the number is positive, negative, or equal to zero, use the following format:</paragraph> - <paragraph xml-lang="en-US" id="par_id3153727" role="example" l10n="U" oldref="92">"plus" 0;"minus" 0;"null" 0</paragraph> - <paragraph xml-lang="en-US" id="hd_id3149260" role="heading" level="2" l10n="U" - oldref="83">Percentages and Scientific Notation</paragraph> - <paragraph xml-lang="en-US" id="hd_id3147218" role="heading" level="3" l10n="U" - oldref="237">Percentages</paragraph> - <paragraph xml-lang="en-US" id="par_id3151168" role="paragraph" l10n="CHG" oldref="84">To display numbers as percentages, add the percent sign (%) to the number format.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3156005" role="heading" level="3" l10n="U" - oldref="89">Scientific Notation</paragraph> - <paragraph xml-lang="en-US" id="par_id3146923" role="paragraph" l10n="U" oldref="85">Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 10^5, and 0.000065 as 6.5 x 10^-5. <comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3159080" role="heading" level="2" l10n="U" - oldref="98">Number Format Codes of Currency Formats</paragraph> - <paragraph xml-lang="en-US" id="par_id3147318" role="paragraph" l10n="CHG" oldref="99">The default currency format for the cells in your spreadsheet is determined by the regional setting of your operating system. If you want, you can apply a custom currency symbol to a cell. For example, enter #,##0.00 € to display 4.50 € (Euros).<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id3150032" role="paragraph" l10n="U" oldref="167">You can also specify the locale setting for the currency by entering the locale code for the country after the symbol. For example, [$€-407] represents Euros in Germany. To view the locale code for a country, select the country in the <emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format Cells</emph> dialog.</paragraph> - <embed href="text/shared/01/05020300.xhp#waehrungtext"/> - <paragraph xml-lang="en-US" id="hd_id3157309" role="heading" level="2" l10n="U" - oldref="238">Date and Time Formats</paragraph> - <paragraph xml-lang="en-US" id="hd_id3153740" role="heading" level="3" l10n="U" - oldref="37">Date Formats</paragraph> - <paragraph xml-lang="en-US" id="par_id3152791" role="paragraph" l10n="U" oldref="38">To display days, months and years, use the following number format codes. </paragraph> - <paragraph xml-lang="en-US" id="par_id610980" role="warning" l10n="NEW">Not all format codes give meaningful results for all languages.</paragraph> - <table id="tbl_id3147426"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152376" role="tablehead" l10n="U" oldref="39">Format</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159130" role="tablehead" l10n="U" oldref="40">Format Code</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147380" role="tablecontent" l10n="U" oldref="41">Month as 3.</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146928" role="code" l10n="U" oldref="42">M</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145594" role="tablecontent" l10n="U" oldref="43">Month as 03.</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153052" role="code" l10n="U" oldref="44">MM</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145728" role="tablecontent" l10n="U" oldref="45">Month as Jan-Dec</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151073" role="code" l10n="U" oldref="46">MMM</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149909" role="tablecontent" l10n="U" oldref="47">Month as January-December</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155318" role="code" l10n="U" oldref="48">MMMM</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151218" role="tablecontent" l10n="U" oldref="116">First letter of Name of Month</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150420" role="code" l10n="U" oldref="117">MMMMM</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154501" role="tablecontent" l10n="U" oldref="49">Day as 2</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156181" role="code" l10n="U" oldref="50">D</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146969" role="tablecontent" l10n="U" oldref="51">Day as 02</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156358" role="code" l10n="U" oldref="52">DD</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148495" role="tablecontent" l10n="U" oldref="53">Day as Sun-Sat</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3161665" role="code" l10n="U" oldref="54">NN or DDD</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154272" role="tablecontent" l10n="U" oldref="118">Day as Sunday to Saturday</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145164" role="code" l10n="U" oldref="119">NNN or DDDD</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146791" role="tablecontent" l10n="U" oldref="55">Day followed by comma, as in "Sunday,"</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146081" role="code" l10n="U" oldref="56">NNNN</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156275" role="tablecontent" l10n="U" oldref="57">Year as 00-99</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3143236" role="code" l10n="U" oldref="58">YY</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148408" role="tablecontent" l10n="U" oldref="59">Year as 1900-2078</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151358" role="code" l10n="U" oldref="60">YYYY</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153355" role="tablecontent" l10n="U" oldref="96">Calendar week</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150744" role="code" l10n="U" oldref="97">WW</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154302" role="tablecontent" l10n="U" oldref="103">Quarterly as Q1 to Q4</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159266" role="code" l10n="CHG" oldref="104">Q</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147583" role="tablecontent" l10n="U" oldref="105">Quarterly as 1st quarter to 4th quarter</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146918" role="code" l10n="U" oldref="106">QQ</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147534" role="tablecontent" l10n="U" oldref="120">Era on the Japanese Gengou calendar, single character (possible values are: M, T, S, H)</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151249" role="code" l10n="U" oldref="121">G</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3163806" role="tablecontent" l10n="U" oldref="122">Era, abbreviation</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155962" role="code" l10n="U" oldref="123">GG</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151187" role="tablecontent" l10n="U" oldref="124">Era, full name</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149568" role="code" l10n="U" oldref="125">GGG</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147344" role="tablecontent" l10n="U" oldref="126">Number of the year within an era, without a leading zero for single-digit years</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147255" role="code" l10n="U" oldref="127">E</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148487" role="tablecontent" l10n="U" oldref="128">Number of the year within an era, with a leading zero for single-digit years</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150298" role="code" l10n="U" oldref="129">EE or R</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152861" role="tablecontent" l10n="U" oldref="138">Era, full name and year</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149926" role="code" l10n="U" oldref="139">RR or GGGEE</paragraph> - </tablecell> - </tablerow> - </table> - - <paragraph xml-lang="en-US" id="par_id1002200811423518" role="paragraph" l10n="NEW">The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you will need to know the formatting codes used in that other locale. </paragraph> - <paragraph xml-lang="en-US" id="par_id1002200811423556" role="paragraph" l10n="NEW">For example, if your software is set to an English locale, and you want to format a year with four digits, you enter YYYY as a formatting code. When you switch to a German locale, you must use JJJJ instead. The following table lists only the localized differences.</paragraph> - <table id="tbl_id1002200811465915"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563044" role="tablehead" l10n="NEW">Locale</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563137" role="tablehead" l10n="NEW">Year</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563164" role="tablehead" l10n="NEW">Month</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563128" role="tablehead" l10n="NEW">Day</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563135" role="tablehead" l10n="NEW">Hour</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563289" role="tablehead" l10n="NEW">Day Of Week</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156322" role="tablehead" l10n="NEW">Era</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563233" role="tablecontent" l10n="NEW">English - en</paragraph> - <paragraph xml-lang="en-US" id="par_id1002200811563243" role="tablecontent" l10n="NEW">and all not listed locales</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563352" role="tablecontent" l10n="NEW">Y</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563396" role="tablecontent" l10n="NEW">M</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563385" role="tablecontent" l10n="NEW">D</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563472" role="tablecontent" l10n="NEW">H</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563430" role="tablecontent" l10n="NEW">A</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563488" role="tablecontent" l10n="NEW">G</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563484" role="tablecontent" l10n="NEW">German - de</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563518" role="tablecontent" l10n="NEW">J</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563735" role="tablecontent" l10n="NEW">T</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563823" role="tablecontent" l10n="NEW">Netherlands - nl</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563852" role="tablecontent" l10n="NEW">J</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563827" role="tablecontent" l10n="NEW">U</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563916" role="tablecontent" l10n="NEW">French - fr</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563970" role="tablecontent" l10n="NEW">A</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811563980" role="tablecontent" l10n="NEW">J</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564065" role="tablecontent" l10n="NEW">O</paragraph> - </tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156407" role="tablecontent" l10n="NEW">Italian - it</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156403" role="tablecontent" l10n="NEW">A</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564042" role="tablecontent" l10n="NEW">G</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156412" role="tablecontent" l10n="NEW">O</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564119" role="tablecontent" l10n="NEW">X</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564197" role="tablecontent" l10n="NEW">Portuguese - pt</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564272" role="tablecontent" l10n="NEW">A</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156423" role="tablecontent" l10n="NEW">O</paragraph> - </tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564218" role="tablecontent" l10n="NEW">Spanish - es</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564390" role="tablecontent" l10n="NEW">A</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564319" role="tablecontent" l10n="NEW">O</paragraph> - </tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156433" role="tablecontent" l10n="NEW">Danish - da</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id100220081156444" role="tablecontent" l10n="NEW">T</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564448" role="tablecontent" l10n="NEW">Norwegian - no, nb, nn</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564549" role="tablecontent" l10n="NEW">T</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564565" role="tablecontent" l10n="NEW">Swedish - sv</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564556" role="tablecontent" l10n="NEW">T</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564637" role="tablecontent" l10n="NEW">Finnish - fi</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564627" role="tablecontent" l10n="NEW">V</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564643" role="tablecontent" l10n="NEW">K</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564763" role="tablecontent" l10n="NEW">P</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id1002200811564715" role="tablecontent" l10n="NEW">T</paragraph> - </tablecell> - <tablecell> -</tablecell> - <tablecell> -</tablecell> - </tablerow> - </table> +<paragraph role="paragraph" id="par_id3150467" xml-lang="en-US" l10n="U" oldref="88">Number format codes can consist of up to three sections separated by a semicolon (;).</paragraph> +<list type="ordered"> +<listitem> +<paragraph role="listitem" id="par_id3150146" xml-lang="en-US" l10n="U" oldref="108">In a number format code with two sections, the first section applies to positive values and zero, and the second section applies to negative values.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3158442" xml-lang="en-US" l10n="CHG" oldref="109">In a number format code with three sections, the first section applies to positive values, the second section to negative values, and the third section to the value zero.</paragraph> +</listitem> +</list> +<list type="ordered"> +<listitem> +<paragraph role="listitem" id="par_id3155069" xml-lang="en-US" l10n="U" oldref="110">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> +</listitem> +</list> +<paragraph role="heading" id="hd_id3151262" xml-lang="en-US" level="2" l10n="U" oldref="229">Decimal Places and Significant Digits</paragraph> +<paragraph role="paragraph" id="par_id3153624" xml-lang="en-US" l10n="U" oldref="3">Use zero (0) or the number sign (#) as placeholders in your number format code to represent numbers. The (#) only displays significant digits, while the (0) displays zeroes if there are fewer digits in the number than in the number format.</paragraph> +<paragraph role="paragraph" id="par_id3153323" xml-lang="en-US" l10n="U" oldref="107">Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers.</paragraph> +<paragraph role="paragraph" id="par_id3148440" xml-lang="en-US" l10n="U" oldref="4">If a number contains more digits to the right of the decimal delimiter than there are placeholders in the format, the number is rounded accordingly. If a number contains more digits to the left of the decimal delimiter than there are placeholders in the format, the entire number is displayed. Use the following list as a guide for using placeholders when you create a number format code:</paragraph> +<table id="tbl_id3149760"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3150902" xml-lang="en-US" l10n="U" oldref="86">Placeholders</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3157896" xml-lang="en-US" l10n="U" oldref="87">Explanation</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="code" id="par_id3152801" xml-lang="en-US" l10n="U" oldref="5">#</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3145090" xml-lang="en-US" l10n="U" oldref="6">Does not display extra zeros.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="code" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="7">0 (Zero)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150774" xml-lang="en-US" l10n="U" oldref="8">Displays extra zeros if the number has less places than zeros in the format.</paragraph> +</tablecell> +</tablerow> +</table> - <paragraph xml-lang="en-US" id="hd_id3149929" role="heading" level="3" l10n="U" - oldref="227">Entering Dates</paragraph> - <paragraph xml-lang="en-US" id="par_id3148397" role="paragraph" l10n="U" oldref="228">To enter a date in a cell, use the Gregorian calendar format. For example, in an English locale, enter 1/2/2002 for Jan 2, 2002.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153274" role="paragraph" l10n="U" oldref="137">All date formats are dependent on the locale that is set in <emph>Tools - Options - Language settings - Languages</emph>. For example, if your locale is set to 'Japanese', then the Gengou calendar is used. The default date format in <item type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153795" role="paragraph" l10n="U" oldref="216">To specify a calendar format that is independent of the locale, add a modifier in front of the date format. For example, to display a date using the Jewish calendar format in a non-Hebrew locale, enter: [~jewish]DD/MM/YYYY.</paragraph> - <table id="tbl_id3145133"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145764" role="tablehead" l10n="U" oldref="217">Modifier</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152967" role="tablehead" l10n="U" oldref="218">Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148390" role="code" l10n="U" oldref="219">[~buddhist]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153781" role="tablecontent" l10n="U" oldref="220">Thai Buddhist Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3157969" role="code" l10n="U" oldref="133">[~gengou]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154656" role="tablecontent" l10n="U" oldref="134">Japanese Gengou Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150086" role="code" l10n="U" oldref="131">[~gregorian]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146070" role="tablecontent" l10n="U" oldref="132">Gregorian Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146808" role="code" l10n="U" oldref="221">[~hanja] or [~hanja_yoil]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149207" role="tablecontent" l10n="U" oldref="136">Korean Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150304" role="code" l10n="U" oldref="222">[~hijri]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149238" role="tablecontent" l10n="U" oldref="223">Arabic Islamic Calendar, currently supported for the following locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154903" role="code" l10n="U" oldref="224">[~jewish]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151288" role="tablecontent" l10n="U" oldref="225">Jewish Calendar</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3166442" role="code" l10n="U" oldref="135">[~ROC]</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145587" role="tablecontent" l10n="U" oldref="226">Republic Of China Calendar</paragraph> - </tablecell> - </tablerow> - </table> +<paragraph role="heading" id="par_idN1087E" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph> +<table id="tbl_id3153577"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3149182" xml-lang="en-US" l10n="U" oldref="9">Number Format</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3154749" xml-lang="en-US" l10n="U" oldref="10">Format Code</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3148538" xml-lang="en-US" l10n="U" oldref="11">3456.78 as 3456.8</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3150355" xml-lang="en-US" l10n="U" oldref="12">####.#</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="13">9.9 as 9.900</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3159256" xml-lang="en-US" l10n="U" oldref="14">#.000</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3147077" xml-lang="en-US" l10n="U" oldref="15">13 as 13.0 and 1234.567 as 1234.57</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U" oldref="16">#.0#</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149578" xml-lang="en-US" l10n="U" oldref="17">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="18"># ???/???</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3156152" xml-lang="en-US" l10n="U" oldref="19">.5 as 0.5</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3149762" xml-lang="en-US" l10n="U" oldref="20">0.##</paragraph> +</tablecell> +</tablerow> +</table> <paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3" l10n="U" oldref="230">Thousands Separator</paragraph> <paragraph role="paragraph" id="par_id3154380" xml-lang="en-US" l10n="U" oldref="21">Depending on your language setting, you can use a comma or a period as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.</paragraph> @@ -1352,376 +745,372 @@ <switch select="appl"> <case select="CALC"> <table id="tbl_id3150490"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154194" role="tablehead" l10n="U" oldref="141">Initial Format</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149787" role="tablehead" l10n="U" oldref="142">Result Format</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152993" role="tablecontent" l10n="U" oldref="143">Date + Date</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150292" role="tablecontent" l10n="U" oldref="144">Number (Days)</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150460" role="tablecontent" l10n="U" oldref="145">Date + Number</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154371" role="tablecontent" l10n="U" oldref="146">Date</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145082" role="tablecontent" l10n="U" oldref="147">Date + Time</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156290" role="tablecontent" l10n="U" oldref="148">Date&Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152456" role="tablecontent" l10n="U" oldref="149">Date + Date&Time</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156169" role="tablecontent" l10n="U" oldref="150">Number</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154527" role="tablecontent" l10n="U" oldref="151">Time + Time</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159625" role="tablecontent" l10n="U" oldref="152">Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146802" role="tablecontent" l10n="U" oldref="153">Time + Number</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146770" role="tablecontent" l10n="U" oldref="154">Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155500" role="tablecontent" l10n="U" oldref="155">Time + Date&Time</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155128" role="tablecontent" l10n="U" oldref="156">Date&Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152904" role="tablecontent" l10n="U" oldref="157">Date&Time + Date&Time</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159143" role="tablecontent" l10n="U" oldref="158">Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148909" role="tablecontent" l10n="U" oldref="159">Date&Time + Number</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154806" role="tablecontent" l10n="U" oldref="160">Date&Time</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151269" role="tablecontent" l10n="U" oldref="161">Number + Number</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154951" role="tablecontent" l10n="U" oldref="162">Number</paragraph> - </tablecell> - </tablerow> - </table> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3154194" xml-lang="en-US" l10n="U" oldref="141">Initial Format</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3149787" xml-lang="en-US" l10n="U" oldref="142">Result Format</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3152993" xml-lang="en-US" l10n="U" oldref="143">Date + Date</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150292" xml-lang="en-US" l10n="U" oldref="144">Number (Days)</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3150460" xml-lang="en-US" l10n="U" oldref="145">Date + Number</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154371" xml-lang="en-US" l10n="U" oldref="146">Date</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3145082" xml-lang="en-US" l10n="U" oldref="147">Date + Time</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3156290" xml-lang="en-US" l10n="U" oldref="148">Date&Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3152456" xml-lang="en-US" l10n="U" oldref="149">Date + Date&Time</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3156169" xml-lang="en-US" l10n="U" oldref="150">Number</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3154527" xml-lang="en-US" l10n="U" oldref="151">Time + Time</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3159625" xml-lang="en-US" l10n="U" oldref="152">Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3146802" xml-lang="en-US" l10n="U" oldref="153">Time + Number</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3146770" xml-lang="en-US" l10n="U" oldref="154">Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3155500" xml-lang="en-US" l10n="U" oldref="155">Time + Date&Time</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3155128" xml-lang="en-US" l10n="U" oldref="156">Date&Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3152904" xml-lang="en-US" l10n="U" oldref="157">Date&Time + Date&Time</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3159143" xml-lang="en-US" l10n="U" oldref="158">Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3148909" xml-lang="en-US" l10n="U" oldref="159">Date&Time + Number</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154806" xml-lang="en-US" l10n="U" oldref="160">Date&Time</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3151269" xml-lang="en-US" l10n="U" oldref="161">Number + Number</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154951" xml-lang="en-US" l10n="U" oldref="162">Number</paragraph> +</tablecell> +</tablerow> +</table> </case> </switch> -<paragraph xml-lang="en-US" id="par_id3149174" role="paragraph" l10n="U" oldref="163"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. +<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US" l10n="U" oldref="163"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format. </caseinline></switchinline></paragraph> <switch select="appl"> <case select="CALC"><embed href="text/shared/optionen/01010600.xhp#jahreszahlen"/> - <paragraph xml-lang="en-US" id="par_id3143225" role="note" l10n="U" oldref="164">In <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> +<paragraph role="note" id="par_id3143225" xml-lang="en-US" l10n="U" oldref="164">In <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> </case> </switch> -<paragraph xml-lang="en-US" id="hd_id3155870" role="heading" level="3" l10n="U" - oldref="61">Time Formats</paragraph> - <paragraph xml-lang="en-US" id="par_id3150108" role="paragraph" l10n="U" oldref="62">To display hours, minutes and seconds use the following number format codes.</paragraph> - <table id="tbl_id3154830"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149158" role="tablehead" l10n="U" oldref="63">Format</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154341" role="tablehead" l10n="U" oldref="64">Format Code</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154557" role="tablecontent" l10n="U" oldref="65">Hours as 0-23</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156348" role="code" l10n="U" oldref="66">h</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3143218" role="tablecontent" l10n="U" oldref="67">Hours as 00-23</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155266" role="code" l10n="U" oldref="68">hh</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150139" role="tablecontent" l10n="U" oldref="69">Minutes as 0-59</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149588" role="code" l10n="U" oldref="70">m</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150531" role="tablecontent" l10n="U" oldref="71">Minutes as 00-59</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147409" role="code" l10n="U" oldref="72">mm</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154854" role="tablecontent" l10n="U" oldref="73">Seconds as 0-59</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156173" role="code" l10n="U" oldref="74">s</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149506" role="tablecontent" l10n="U" oldref="75">Seconds as 00-59</paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3157981" role="code" l10n="U" oldref="76">ss</paragraph> - </tablecell> - </tablerow> - </table> +<paragraph role="heading" id="hd_id3155870" xml-lang="en-US" level="3" l10n="U" oldref="61">Time Formats</paragraph> +<paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U" oldref="62">To display hours, minutes and seconds use the following number format codes.</paragraph> +<table id="tbl_id3154830"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3149158" xml-lang="en-US" l10n="U" oldref="63">Format</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3154341" xml-lang="en-US" l10n="U" oldref="64">Format Code</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3154557" xml-lang="en-US" l10n="U" oldref="65">Hours as 0-23</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U" oldref="66">h</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3143218" xml-lang="en-US" l10n="U" oldref="67">Hours as 00-23</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3155266" xml-lang="en-US" l10n="U" oldref="68">hh</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U" oldref="69">Minutes as 0-59</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3149588" xml-lang="en-US" l10n="U" oldref="70">m</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3150531" xml-lang="en-US" l10n="U" oldref="71">Minutes as 00-59</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3147409" xml-lang="en-US" l10n="U" oldref="72">mm</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3154854" xml-lang="en-US" l10n="U" oldref="73">Seconds as 0-59</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3156173" xml-lang="en-US" l10n="U" oldref="74">s</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149506" xml-lang="en-US" l10n="U" oldref="75">Seconds as 00-59</paragraph> +</tablecell> +<tablecell> +<paragraph role="code" id="par_id3157981" xml-lang="en-US" l10n="U" oldref="76">ss</paragraph> +</tablecell> +</tablerow> +</table> - <paragraph xml-lang="en-US" id="par_id3156039" role="note" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id3148649" role="paragraph" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id0929200911242399" role="paragraph" l10n="NEW">To display hours beyond 24, use the [HH]:MM:SS format. For example, the following formula ="12:34:56"+"14:00:00" displays the time in the form of "26:34:56".</paragraph> - <paragraph xml-lang="en-US" id="hd_id3158404" role="heading" level="3" l10n="U" - oldref="169">Displaying Numbers Using Native Characters</paragraph> - <paragraph xml-lang="en-US" id="par_id3149998" role="paragraph" l10n="U" oldref="170">To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154600" role="paragraph" l10n="U" oldref="171">The [NatNum1] modifier always uses a one to one character mapping to convert numbers to a string that matches the native number format code of the corresponding locale. The other modifiers produce different results if they are used with different locales. A locale can be the language and the territory for which the format code is defined, or a modifier such as [$-yyy] that follows the native number modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in currency format codes. For example, to display a number using Japanese short Kanji characters in an English US locale, use the following number format code:</paragraph> - <paragraph xml-lang="en-US" id="par_id3152546" role="example" l10n="U" oldref="172">[NatNum1][$-411]0</paragraph> - <paragraph xml-lang="en-US" id="par_id3147269" role="paragraph" l10n="U" oldref="173">In the following list, the Microsoft Excel [DBNumX] modifier that corresponds to <item type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want, you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale. Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps [DBNumX] modifiers to [NatNumN] modifiers.</paragraph> - <paragraph xml-lang="en-US" id="par_idN11234" role="paragraph" l10n="NEW">Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153111" role="heading" level="3" l10n="CHG" - oldref="174">[NatNum1] Transliterations</paragraph> - <table id="tbl_id1136841"> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146895" role="paragraph" l10n="U" oldref="175">Chinese: Chinese lower case characters; CAL: 1/7/7 [DBNum1]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152536" role="paragraph" l10n="U" oldref="176">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3146125" role="paragraph" l10n="U" oldref="177">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7 [DBNum1]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149945" role="paragraph" l10n="U" oldref="178">Thai: Thai characters</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153264" role="paragraph" l10n="U" oldref="179">Arabic: Indic characters</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3148973" role="paragraph" l10n="U" oldref="180">Indic: Indic characters</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_idN112A3" role="paragraph" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3147520" role="paragraph" l10n="U" oldref="181">[NatNum2] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155383" role="paragraph" l10n="U" oldref="182">Chinese: Chinese upper case characters; CAL: 2/8/8 [DBNum2]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153931" role="paragraph" l10n="U" oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155097" role="paragraph" l10n="U" oldref="184">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8 [DBNum2]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152976" role="paragraph" l10n="U" oldref="185">[NatNum3] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154353" role="paragraph" l10n="U" oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154669" role="paragraph" l10n="U" oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150472" role="paragraph" l10n="U" oldref="188">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3 [DBNum3]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3157811" role="paragraph" l10n="U" oldref="189">[NatNum4] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154592" role="paragraph" l10n="U" oldref="190">Chinese: lower case text [DBNum1]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150350" role="paragraph" l10n="U" oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150930" role="paragraph" l10n="U" oldref="192">Korean: formal lower case text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153546" role="paragraph" l10n="U" oldref="193">[NatNum5] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155612" role="paragraph" l10n="U" oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155909" role="paragraph" l10n="U" oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3151304" role="paragraph" l10n="U" oldref="196">Korean: formal upper case text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155075" role="paragraph" l10n="U" oldref="197">[NatNum6] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150214" role="paragraph" l10n="U" oldref="198">Chinese: fullwidth text [DBNum3]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154114" role="paragraph" l10n="U" oldref="199">Japanese: fullwidth text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155344" role="paragraph" l10n="U" oldref="200">Korean: fullwidth text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155538" role="paragraph" l10n="U" oldref="201">[NatNum7] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145123" role="paragraph" l10n="U" oldref="202">Japanese: modern short Kanji text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149424" role="paragraph" l10n="U" oldref="203">Korean: informal lower case text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153688" role="paragraph" l10n="U" oldref="204">[NatNum8] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3156122" role="paragraph" l10n="U" oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3145602" role="paragraph" l10n="U" oldref="206">Korean: informal upper case text</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3159228" role="paragraph" l10n="U" oldref="207">[NatNum9] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154644" role="paragraph" l10n="U" oldref="208">Korean: Hangul characters</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3155396" role="paragraph" l10n="U" oldref="209">[NatNum10] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3150878" role="paragraph" l10n="U" oldref="210">Korean: formal Hangul text [DBNum4]; CAL: 9/11/11 [DBNum4]</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3149384" role="paragraph" l10n="U" oldref="211">[NatNum11] Transliteration in</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3154213" role="paragraph" l10n="U" oldref="212">Korean: informal Hangul text</paragraph> - </tablecell> - </tablerow> - </table> +<paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U" oldref="77">To display seconds as fractions, add the decimal delimiter to your number format code. For example, enter <emph>hh:mm:ss.00</emph> to display the time as "01:02:03.45".<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> +<paragraph role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U" oldref="102">If a time is entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment></paragraph> +<paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph> +<paragraph role="paragraph" id="par_id3149998" xml-lang="en-US" l10n="U" oldref="170">To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes.</paragraph> +<paragraph role="paragraph" id="par_id3154600" xml-lang="en-US" l10n="U" oldref="171">The [NatNum1] modifier always uses a one to one character mapping to convert numbers to a string that matches the native number format code of the corresponding locale. The other modifiers produce different results if they are used with different locales. A locale can be the language and the territory for which the format code is defined, or a modifier such as [$-yyy] that follows the native number modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in currency format codes. For example, to display a number using Japanese short Kanji characters in an English US locale, use the following number format code:</paragraph> +<paragraph role="example" id="par_id3152546" xml-lang="en-US" l10n="U" oldref="172">[NatNum1][$-411]0</paragraph> +<paragraph role="paragraph" id="par_id3147269" xml-lang="en-US" l10n="U" oldref="173">In the following list, the Microsoft Excel [DBNumX] modifier that corresponds to <item type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want, you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale. Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps [DBNumX] modifiers to [NatNumN] modifiers.</paragraph> +<paragraph role="paragraph" id="par_idN11234" xml-lang="en-US" l10n="NEW">Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported.</paragraph> +<paragraph role="heading" id="par_id3153111" xml-lang="en-US" level="3" l10n="CHG" oldref="174">[NatNum1] Transliterations</paragraph> +<table id="tbl_id1136841"> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3146895" xml-lang="en-US" l10n="U" oldref="175">Chinese: Chinese lower case characters; CAL: 1/7/7 [DBNum1]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3152536" xml-lang="en-US" l10n="U" oldref="176">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3146125" xml-lang="en-US" l10n="U" oldref="177">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7 [DBNum1]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149945" xml-lang="en-US" l10n="U" oldref="178">Thai: Thai characters</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153264" xml-lang="en-US" l10n="U" oldref="179">Arabic: Indic characters</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3148973" xml-lang="en-US" l10n="U" oldref="180">Indic: Indic characters</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_idN112A3" xml-lang="en-US" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3147520" xml-lang="en-US" l10n="U" oldref="181">[NatNum2] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U" oldref="182">Chinese: Chinese upper case characters; CAL: 2/8/8 [DBNum2]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153931" xml-lang="en-US" l10n="U" oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U" oldref="184">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8 [DBNum2]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3152976" xml-lang="en-US" l10n="U" oldref="185">[NatNum3] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154353" xml-lang="en-US" l10n="U" oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154669" xml-lang="en-US" l10n="U" oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150472" xml-lang="en-US" l10n="U" oldref="188">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3 [DBNum3]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3157811" xml-lang="en-US" l10n="U" oldref="189">[NatNum4] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154592" xml-lang="en-US" l10n="U" oldref="190">Chinese: lower case text [DBNum1]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150350" xml-lang="en-US" l10n="U" oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="192">Korean: formal lower case text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153546" xml-lang="en-US" l10n="U" oldref="193">[NatNum5] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155612" xml-lang="en-US" l10n="U" oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155909" xml-lang="en-US" l10n="U" oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3151304" xml-lang="en-US" l10n="U" oldref="196">Korean: formal upper case text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155075" xml-lang="en-US" l10n="U" oldref="197">[NatNum6] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U" oldref="198">Chinese: fullwidth text [DBNum3]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154114" xml-lang="en-US" l10n="U" oldref="199">Japanese: fullwidth text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155344" xml-lang="en-US" l10n="U" oldref="200">Korean: fullwidth text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155538" xml-lang="en-US" l10n="U" oldref="201">[NatNum7] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145123" xml-lang="en-US" l10n="U" oldref="202">Japanese: modern short Kanji text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149424" xml-lang="en-US" l10n="U" oldref="203">Korean: informal lower case text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3153688" xml-lang="en-US" l10n="U" oldref="204">[NatNum8] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="U" oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3145602" xml-lang="en-US" l10n="U" oldref="206">Korean: informal upper case text</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3159228" xml-lang="en-US" l10n="U" oldref="207">[NatNum9] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154644" xml-lang="en-US" l10n="U" oldref="208">Korean: Hangul characters</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3155396" xml-lang="en-US" l10n="U" oldref="209">[NatNum10] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3150878" xml-lang="en-US" l10n="U" oldref="210">Korean: formal Hangul text [DBNum4]; CAL: 9/11/11 [DBNum4]</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3149384" xml-lang="en-US" l10n="U" oldref="211">[NatNum11] Transliteration in</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="paragraph" id="par_id3154213" xml-lang="en-US" l10n="U" oldref="212">Korean: informal Hangul text</paragraph> +</tablecell> +</tablerow> +</table> - </body> -</helpdocument>
\ No newline at end of file +</body> +</helpdocument> |