diff options
Diffstat (limited to 'helpcontent2/source/text/shared/01/05020301.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/01/05020301.xhp | 2583 |
1 files changed, 2583 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp new file mode 100644 index 000000000..6cfb83564 --- /dev/null +++ b/helpcontent2/source/text/shared/01/05020301.xhp @@ -0,0 +1,2583 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <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_value>percentages, formats</bookmark_value> + <bookmark_value>scientific notation, formats</bookmark_value> + <bookmark_value>engineering notation, formats</bookmark_value> + <bookmark_value>fraction, formats</bookmark_value> + <bookmark_value>native numeral</bookmark_value> + <bookmark_value>LCID, extended</bookmark_value> +</bookmark> +<comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment> + +<paragraph id="hd_id3153514" role="heading" level="1" xml-lang="en-US"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> </variable></paragraph> +<paragraph id="par_id3150467" role="paragraph" xml-lang="en-US">Number format codes can consist of up to four sections separated by a semicolon (<emph>;</emph>).</paragraph> + +<list type="ordered"> + <listitem> + <paragraph id="par_id3150146" role="listitem" xml-lang="en-US">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 id="par_id3158442" role="listitem" xml-lang="en-US">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> + <listitem> + <paragraph id="par_id3155069" role="listitem" xml-lang="en-US">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id3155070" role="listitem" xml-lang="en-US">Fourth section applies if the content is not a value, but some text. Content is represented by an at sign (<emph>@</emph>).</paragraph> + </listitem> +</list> + +<paragraph id="hd_id3151262" role="heading" level="2" xml-lang="en-US">Decimal Places and Significant Digits</paragraph> + <paragraph id="par_id3153624" role="paragraph" xml-lang="en-US">Use zero (<emph>0</emph>), the number sign (<emph>#</emph>) or the question mark (<emph>?</emph>) as placeholders in your number format code to represent numbers. The <emph>#</emph> only displays significant digits, while the <emph>0</emph> displays zeroes if there are fewer digits in the number than in the number format. The <emph>?</emph> works as the <emph>#</emph> but adds a space character to keep decimal alignment if there is a hidden non-significant zero.</paragraph> + <paragraph id="par_id3153323" role="paragraph" xml-lang="en-US">Use question marks (<emph>?</emph>), zeroes (<emph>0</emph>) or number signs (<emph>#</emph>) 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 id="par_id3148440" role="paragraph" xml-lang="en-US">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 id="par_id3150902" role="tablehead" xml-lang="en-US">Placeholders</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3157896" role="tablehead" xml-lang="en-US">Explanation</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152801" role="code" localize="false" xml-lang="en-US">#</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3145090" role="tablecontent" xml-lang="en-US">Does not display extra zeros.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152802" role="code" localize="false" xml-lang="en-US">?</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3145091" role="tablecontent" xml-lang="en-US">Displays space characters instead of extra zeros.</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147088" role="code" xml-lang="en-US">0 (Zero)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150774" role="tablecontent" xml-lang="en-US">Displays extra zeros if the number has less places than zeros in the format.</paragraph> + </tablecell> + </tablerow> +</table> + + +<paragraph id="par_idN1087E" role="heading" level="3" xml-lang="en-US">Examples</paragraph> + +<table id="tbl_id3153577"> + <tablerow> + <tablecell> + <paragraph id="par_id3149182" role="tablehead" xml-lang="en-US">Number Format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154749" role="tablehead" xml-lang="en-US">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148538" role="tablecontent" xml-lang="en-US">3456.78 as 3456.8</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150355" role="code" localize="false" xml-lang="en-US">####.#</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154142" role="tablecontent" xml-lang="en-US">9.9 as 9.900</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3159256" role="code" localize="false" xml-lang="en-US">#.000</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147077" role="tablecontent" xml-lang="en-US">13 as 13.0 and 1234.567 as 1234.57</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155388" role="code" localize="false" xml-lang="en-US">#.0#</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3149578" role="tablecontent" xml-lang="en-US">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3145315" role="code" localize="false" xml-lang="en-US"># ???/???</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3156152" role="tablecontent" xml-lang="en-US">.5 as 0.5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149762" role="code" localize="false" xml-lang="en-US">0.##</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3156153" role="tablecontent" xml-lang="en-US">.5 as 0.5 (with two extra spaces at the end)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149763" role="code" localize="false" xml-lang="en-US">0.???</paragraph> + </tablecell> + </tablerow> +</table> + + +<paragraph id="hd_id3149276" role="heading" level="3" xml-lang="en-US">Thousands Separator</paragraph> +<paragraph id="par_id3154380" role="paragraph" xml-lang="en-US">Depending on your language setting, you can use a comma, a period or a blank 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 for each separator. The examples below use comma as thousands separator:</paragraph> + +<table id="tbl_id3150244"> + <tablerow> + <tablecell> + <paragraph id="par_id3154905" role="tablehead" xml-lang="en-US">Number Format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150822" role="tablehead" xml-lang="en-US">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147264" role="tablecontent" xml-lang="en-US">15000 as 15,000</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3151223" role="code" localize="false" xml-lang="en-US">#,###</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154935" role="tablecontent" xml-lang="en-US">16000 as 16</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3153961" role="code" localize="false" xml-lang="en-US">#,</paragraph> + </tablecell> + </tablerow> +</table> + + +<paragraph id="hd_id3154836" role="heading" level="2" xml-lang="en-US">Including Text in Number Format Codes</paragraph> + +<paragraph id="hd_id3150398" role="heading" level="3" xml-lang="en-US">Text and Numbers</paragraph> +<paragraph id="par_id3154224" role="paragraph" xml-lang="en-US">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". If you use space as thousands separator, you need to insert spaces between quotes in the previous examples: <emph>#.#" meters"</emph> or <emph>#.#\ \m</emph> to get the correct result.</paragraph> + +<paragraph id="hd_id3148979" role="heading" level="3" xml-lang="en-US">Text and Text</paragraph> +<paragraph id="par_id3153338" role="paragraph" xml-lang="en-US">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 id="hd_id3154330" role="heading" level="3" xml-lang="en-US">Spaces</paragraph> +<paragraph id="par_id3156294" role="paragraph" xml-lang="en-US">To use a character to define the width of a space in a number format, type an underscore (<emph>_</emph>) 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 id="par_id3156295" role="paragraph" xml-lang="en-US">To fill free space with a given character, use an asterisk (<emph>*</emph>) followed by this character. For instance:</paragraph> +<paragraph id="par_id3156296" role="code" localize="false" xml-lang="en-US">*\0</paragraph> +<paragraph id="par_id3156297" role="paragraph" xml-lang="en-US">will display integer value (0) preceded by as many as needed backslash characters (<emph>\</emph>) to fill column width. For accounting representation, you may left align currency symbol with a format similar to:</paragraph> +<paragraph id="par_id3156298" role="code" localize="false" xml-lang="en-US">$_-* 0.--;$-* 0.--;$_-* -</paragraph> + +<paragraph id="hd_id3155994" role="heading" level="2" xml-lang="en-US">Color</paragraph> +<paragraph id="par_id3156423" role="paragraph" xml-lang="en-US">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 id="par_id3154630" role="code" localize="false" xml-lang="en-US">CYAN</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3148676" role="code" localize="false" xml-lang="en-US">GREEN</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154123" role="code" localize="false" xml-lang="en-US">BLACK</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149167" role="code" localize="false" xml-lang="en-US">BLUE</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3158407" role="code" localize="false" xml-lang="en-US">MAGENTA</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149560" role="code" localize="false" xml-lang="en-US">RED</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147502" role="code" localize="false" xml-lang="en-US">WHITE</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3153368" role="code" localize="false" xml-lang="en-US">YELLOW</paragraph> + </tablecell> + </tablerow> +</table> + + +<paragraph id="hd_id3147435" role="heading" level="2" xml-lang="en-US">Conditions</paragraph> + +<paragraph id="hd_id3148575" role="heading" level="3" xml-lang="en-US">Conditional Brackets</paragraph> +<paragraph id="par_id3155312" role="paragraph" xml-lang="en-US">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 id="par_id3159179" role="paragraph" xml-lang="en-US">You can use any combination of numbers and the <, <=, >, >=, = and <> operators.</paragraph> +<paragraph id="par_id3159196" role="paragraph" xml-lang="en-US">For example, if you want to apply different colors to different temperature data, enter:</paragraph> +<paragraph id="par_id3150872" role="example" localize="false" xml-lang="en-US">[BLUE][<0]#.0 "°C";[RED][>30]#.0 "°C";[BLACK]#.0 "°C"</paragraph> +<paragraph id="par_id3157870" role="paragraph" xml-lang="en-US">All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red.</paragraph> + +<paragraph id="hd_id3154833" role="heading" level="3" xml-lang="en-US">Positive and Negative Numbers</paragraph> +<paragraph id="par_id3147295" role="paragraph" xml-lang="en-US">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 id="par_id3153727" role="example" xml-lang="en-US">"plus" 0;"minus" 0;"null" 0</paragraph> + +<paragraph id="hd_id3149260" role="heading" level="2" xml-lang="en-US">Percentages, Scientific Notation and Fraction Representation</paragraph> + +<paragraph id="hd_id3147218" role="heading" level="3" xml-lang="en-US">Percentages</paragraph> +<paragraph id="par_id3151168" role="paragraph" xml-lang="en-US">To display numbers as percentages, add the percent sign (<emph>%</emph>) to the number format.</paragraph> + +<paragraph id="hd_id3156005" role="heading" level="3" xml-lang="en-US">Scientific Notation</paragraph> +<paragraph id="par_id3146923" role="paragraph" xml-lang="en-US">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<sup>5</sup>, and 0.000065 as 6.5 x 10<sup>-5</sup>. <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+. If sign is omitted after E or e, it won't appear for positive value of exponent. To get engineering notation, enter 3 digits (0 or #) in the integer part: <emph>###.##E+00</emph> for instance.</paragraph> + +<paragraph id="hd_id3156006" role="heading" level="3" xml-lang="en-US">Fraction Representation</paragraph> +<paragraph id="par_id3146924" role="paragraph" xml-lang="en-US">To represent a value as a fraction, format consists of two or three parts: integer optional part, numerator and denominator. Integer and numerator are separated by a blank or any quoted text. Numerator and denominator are separated by a slash character. Each part can consist of a combination of #, ? and 0 as placeholders.</paragraph> +<paragraph id="par_id3146925" role="paragraph" xml-lang="en-US">Denominator is calculated to get the nearest value of the fraction with respect to the number of placeholders. For example, PI value is represented as 3 16/113 with format:</paragraph> +<paragraph id="par_id3146926" role="example" localize="false" xml-lang="en-US"># ?/???</paragraph> +<paragraph id="par_id3146927" role="paragraph" xml-lang="en-US">Denominator value can also be forced to the value replacing placeholders. For example, to get PI value as a multiple of 1/16th (i.e. 50/16), use format:</paragraph> +<paragraph id="par_id3146929" role="example" localize="false" xml-lang="en-US">?/16</paragraph> + +<paragraph id="hd_id3159080" role="heading" level="2" xml-lang="en-US">Number Format Codes of Currency Formats</paragraph> +<paragraph id="par_id3147318" role="paragraph" xml-lang="en-US">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 id="par_id3150032" role="paragraph" xml-lang="en-US">You can also specify the locale setting for the currency by entering the locale code for the country after the symbol. For example, <emph>[$€-407]</emph> 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#currencytext"/> + +<paragraph id="hd_id3157309" role="heading" level="2" xml-lang="en-US">Date and Time Formats</paragraph> + +<paragraph id="hd_id3153740" role="heading" level="3" xml-lang="en-US">Date Formats</paragraph> +<paragraph id="par_id3152791" role="paragraph" xml-lang="en-US">To display days, months and years, use the following number format codes. </paragraph> +<paragraph id="par_id610980" role="warning" xml-lang="en-US">Not all format codes give meaningful results for all languages.</paragraph> + +<table id="tbl_id3147426"> + <tablerow> + <tablecell> + <paragraph id="par_id3152376" role="tablehead" xml-lang="en-US">Format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3159130" role="tablehead" xml-lang="en-US">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147380" role="tablecontent" xml-lang="en-US">Month as 3.</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3146928" role="code" localize="false" xml-lang="en-US">M</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3145594" role="tablecontent" xml-lang="en-US">Month as 03.</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3153052" role="code" localize="false" xml-lang="en-US">MM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3145728" role="tablecontent" xml-lang="en-US">Month as Jan-Dec</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3151073" role="code" localize="false" xml-lang="en-US">MMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3149909" role="tablecontent" xml-lang="en-US">Month as January-December</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155318" role="code" localize="false" xml-lang="en-US">MMMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3151218" role="tablecontent" xml-lang="en-US">First letter of Name of Month</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150420" role="code" localize="false" xml-lang="en-US">MMMMM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154501" role="tablecontent" xml-lang="en-US">Day as 2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156181" role="code" localize="false" xml-lang="en-US">D</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3146969" role="tablecontent" xml-lang="en-US">Day as 02</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156358" role="code" localize="false" xml-lang="en-US">DD</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148495" role="tablecontent" xml-lang="en-US">Day as Sun-Sat</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3161665" role="code" localize="false" xml-lang="en-US">NN or DDD or AAA</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154272" role="tablecontent" xml-lang="en-US">Day as Sunday to Saturday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3145164" role="code" localize="false" xml-lang="en-US">NNN or DDDD or AAAA</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3146791" role="tablecontent" xml-lang="en-US">Day followed by comma, as in "Sunday,"</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3146081" role="code" localize="false" xml-lang="en-US">NNNN</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3156275" role="tablecontent" xml-lang="en-US">Year as 00-99</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3143236" role="code" localize="false" xml-lang="en-US">YY</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148408" role="tablecontent" xml-lang="en-US">Year as 1900-2078</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3151358" role="code" localize="false" xml-lang="en-US">YYYY</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3153355" role="tablecontent" xml-lang="en-US">Calendar week</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150744" role="code" localize="false" xml-lang="en-US">WW</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154302" role="tablecontent" xml-lang="en-US">Quarterly as Q1 to Q4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3159266" role="code" localize="false" xml-lang="en-US">Q</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147583" role="tablecontent" xml-lang="en-US">Quarterly as 1st quarter to 4th quarter</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3146918" role="code" localize="false" xml-lang="en-US">QQ</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147534" role="tablecontent" xml-lang="en-US">Era, abbreviation. On the Japanese Gengou calendar, single character (possible values are: M, T, S, H)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3151249" role="code" localize="false" xml-lang="en-US">G</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3163806" role="tablecontent" xml-lang="en-US">Era, abbreviation</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155962" role="code" localize="false" xml-lang="en-US">GG</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3151187" role="tablecontent" xml-lang="en-US">Era, full name</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149568" role="code" localize="false" xml-lang="en-US">GGG</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3147344" role="tablecontent" xml-lang="en-US">Number of the year within an era, short format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3147255" role="code" localize="false" xml-lang="en-US">E</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148487" role="tablecontent" xml-lang="en-US">Number of the year within an era, long format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150298" role="code" xml-lang="en-US">EE or R</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152861" role="tablecontent" xml-lang="en-US">Era, full name and year</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149926" role="code" xml-lang="en-US">RR or GGGEE</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id1002200811423518" role="paragraph" xml-lang="en-US">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 need to know the formatting codes used in that other locale.</paragraph> +<paragraph id="par_id1002200811423556" role="paragraph" xml-lang="en-US">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 id="par_id1002200811563044" role="tablehead" xml-lang="en-US">Locale</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563137" role="tablehead" xml-lang="en-US">Year</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563164" role="tablehead" xml-lang="en-US">Month</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563128" role="tablehead" xml-lang="en-US">Day</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563135" role="tablehead" xml-lang="en-US">Hour</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563289" role="tablehead" xml-lang="en-US">Day Of Week</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id100220081156322" role="tablehead" xml-lang="en-US">Era</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811563233" role="tablecontent" localize="false" xml-lang="en-US">English - en</paragraph> + <paragraph id="par_id1002200811563243" role="tablecontent" xml-lang="en-US">and all not listed locales</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563352" role="tablecontent" localize="false" xml-lang="en-US">Y</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563396" role="tablecontent" localize="false" xml-lang="en-US">M</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563385" role="tablecontent" localize="false" xml-lang="en-US">D</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563472" role="tablecontent" localize="false" xml-lang="en-US">H</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563430" role="tablecontent" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563488" role="tablecontent" localize="false" xml-lang="en-US">G</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811563484" role="tablecontent" xml-lang="en-US">German - de</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563518" role="tablecontent" localize="false" xml-lang="en-US">J</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563735" role="tablecontent" localize="false" xml-lang="en-US">T</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811563823" role="tablecontent" xml-lang="en-US">Netherlands - nl</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563852" role="tablecontent" localize="false" xml-lang="en-US">J</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563827" role="tablecontent" localize="false" xml-lang="en-US">U</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811563916" role="tablecontent" xml-lang="en-US">French - fr</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563970" role="tablecontent" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811563980" role="tablecontent" localize="false" xml-lang="en-US">J</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564065" role="tablecontent" localize="false" xml-lang="en-US">O</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id100220081156407" role="tablecontent" xml-lang="en-US">Italian - it</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id100220081156403" role="tablecontent" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564042" role="tablecontent" localize="false" xml-lang="en-US">G</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id100220081156412" role="tablecontent" localize="false" xml-lang="en-US">O</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564119" role="tablecontent" localize="false" xml-lang="en-US">X</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811564197" role="tablecontent" xml-lang="en-US">Portuguese - pt</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564272" role="tablecontent" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id100220081156423" role="tablecontent" localize="false" xml-lang="en-US">O</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811564218" role="tablecontent" xml-lang="en-US">Spanish - es</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564390" role="tablecontent" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564319" role="tablecontent" localize="false" xml-lang="en-US">O</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id100220081156433" role="tablecontent" xml-lang="en-US">Danish - da</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id100220081156444" role="tablecontent" localize="false" xml-lang="en-US">T</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811564448" role="tablecontent" xml-lang="en-US">Norwegian - no, nb, nn</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564549" role="tablecontent" localize="false" xml-lang="en-US">T</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811564565" role="tablecontent" xml-lang="en-US">Swedish - sv</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564556" role="tablecontent" localize="false" xml-lang="en-US">T</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1002200811564637" role="tablecontent" xml-lang="en-US">Finnish - fi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564627" role="tablecontent" localize="false" xml-lang="en-US">V</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564643" role="tablecontent" localize="false" xml-lang="en-US">K</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564763" role="tablecontent" localize="false" xml-lang="en-US">P</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1002200811564715" role="tablecontent" localize="false" xml-lang="en-US">T</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + + +<paragraph id="hd_id3149929" role="heading" level="3" xml-lang="en-US">Entering Dates</paragraph> +<paragraph id="par_id3148397" role="paragraph" xml-lang="en-US">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 id="par_id3153274" role="paragraph" xml-lang="en-US">All date formats are dependent on the locale that is set in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - 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 id="par_id3153795" role="paragraph" xml-lang="en-US">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> +<paragraph id="par_id231020161240096930" role="paragraph" xml-lang="en-US">The specified calendar is exported to Microsoft Excel using extended LCID. Extended LCID can also be used in the format string. It will be converted to a calendar modifier if it is supported. See <link href="text/shared/01/05020301.xhp#ExtendedLCID">Extended LCID</link> section below.</paragraph> + +<table id="tbl_id3145133"> + <tablerow> + <tablecell> + <paragraph id="par_id3145764" role="tablehead" xml-lang="en-US">Modifier</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3152967" role="tablehead" xml-lang="en-US">Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148390" role="code" localize="false" xml-lang="en-US">[~buddhist]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3153781" role="tablecontent" xml-lang="en-US">Thai Buddhist Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3157969" role="code" localize="false" xml-lang="en-US">[~gengou]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154656" role="tablecontent" xml-lang="en-US">Japanese Gengou Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150086" role="code" localize="false" xml-lang="en-US">[~gregorian]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3146070" role="tablecontent" xml-lang="en-US">Gregorian Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3146808" role="code" xml-lang="en-US">[~hanja] or [~hanja_yoil]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149207" role="tablecontent" xml-lang="en-US">Korean Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150304" role="code" localize="false" xml-lang="en-US">[~hijri]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149238" role="tablecontent" xml-lang="en-US">Arabic Islamic Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154903" role="code" localize="false" xml-lang="en-US">[~jewish]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3151288" role="tablecontent" xml-lang="en-US">Jewish Calendar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3166442" role="code" localize="false" xml-lang="en-US">[~ROC]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3145587" role="tablecontent" xml-lang="en-US">Republic Of China Calendar</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id3152419" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">If you perform a calculation that involves one or more cells using a date format, the result is formatted according to the following mappings:</caseinline></switchinline></paragraph> +<switch select="appl"> +<case select="CALC"> + +<table id="tbl_id3150490"> + <tablerow> + <tablecell> + <paragraph id="par_id3154194" role="tablehead" xml-lang="en-US">Initial Format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149787" role="tablehead" xml-lang="en-US">Result Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152993" role="tablecontent" xml-lang="en-US">Date + Date</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3150292" role="tablecontent" xml-lang="en-US">Number (Days)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150460" role="tablecontent" xml-lang="en-US">Date + Number</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154371" role="tablecontent" xml-lang="en-US">Date</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3145082" role="tablecontent" xml-lang="en-US">Date + Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156290" role="tablecontent" xml-lang="en-US">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152456" role="tablecontent" xml-lang="en-US">Date + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156169" role="tablecontent" xml-lang="en-US">Number</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154527" role="tablecontent" xml-lang="en-US">Time + Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3159625" role="tablecontent" xml-lang="en-US">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3146802" role="tablecontent" xml-lang="en-US">Time + Number</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3146770" role="tablecontent" xml-lang="en-US">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3155500" role="tablecontent" xml-lang="en-US">Time + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155128" role="tablecontent" xml-lang="en-US">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3152904" role="tablecontent" xml-lang="en-US">Date&Time + Date&Time</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3159143" role="tablecontent" xml-lang="en-US">Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3148909" role="tablecontent" xml-lang="en-US">Date&Time + Number</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154806" role="tablecontent" xml-lang="en-US">Date&Time</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3151269" role="tablecontent" xml-lang="en-US">Number + Number</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154951" role="tablecontent" xml-lang="en-US">Number</paragraph> + </tablecell> + </tablerow> +</table> + +</case> +</switch> +<paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><switchinline select="appl"><caseinline select="CALC">The <emph>Date & Time</emph> 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#year_digits"/> +<paragraph id="par_id3143225" role="note" xml-lang="en-US">By default in <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> +</case> +</switch> + +<paragraph id="hd_id3155870" role="heading" level="3" xml-lang="en-US">Time Formats</paragraph> +<paragraph id="par_id3150108" role="paragraph" xml-lang="en-US">To display hours, minutes and seconds use the following number format codes:</paragraph> + +<table id="tbl_id3154830"> + <tablerow> + <tablecell> + <paragraph id="par_id3149158" role="tablehead" xml-lang="en-US">Format</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3154341" role="tablehead" xml-lang="en-US">Format Code</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154557" role="tablecontent" xml-lang="en-US">Hours as 0-23</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156348" role="code" localize="false" xml-lang="en-US">H</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3143218" role="tablecontent" xml-lang="en-US">Hours as 00-23</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155266" role="code" localize="false" xml-lang="en-US">HH</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3143219" role="tablecontent" xml-lang="en-US">Hours as 00 up to more than 23</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3155267" role="code" localize="false" xml-lang="en-US">[HH]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150139" role="tablecontent" xml-lang="en-US">Minutes as 0-59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3149588" role="code" localize="false" xml-lang="en-US">M</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150531" role="tablecontent" xml-lang="en-US">Minutes as 00-59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3147409" role="code" localize="false" xml-lang="en-US">MM</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3150532" role="tablecontent" xml-lang="en-US">Minutes as 00 up to more than 59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3147410" role="code" localize="false" xml-lang="en-US">[MM]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3154854" role="tablecontent" xml-lang="en-US">Seconds as 0-59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3156173" role="code" localize="false" xml-lang="en-US">S</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3149506" role="tablecontent" xml-lang="en-US">Seconds as 00-59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3157981" role="code" localize="false" xml-lang="en-US">SS</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id3149507" role="tablecontent" xml-lang="en-US">Seconds as 00 up to more than 59</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id3157982" role="code" localize="false" xml-lang="en-US">[SS]</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id3156039" role="note" xml-lang="en-US">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 id="par_id3148650" role="paragraph" xml-lang="en-US">Minute time formats M and MM must be used in combination with hour or second time formats to avoid confusion with month date format.</paragraph> +<paragraph id="par_id3148649" role="paragraph" xml-lang="en-US">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 id="hd_id3158404" role="heading" level="2" xml-lang="en-US">Displaying Numbers Using Native Characters</paragraph> + +<paragraph id="hd_id231020161309289931" role="heading" level="2" xml-lang="en-US">NatNum modifiers</paragraph> +<paragraph id="par_id3149998" role="paragraph" xml-lang="en-US">To display numbers using native number characters, use a [NatNum1], [NatNum2], ..., [NatNum11] modifier at the beginning of a number format codes.</paragraph><comment>this will be extended with the libnumbertext work</comment> +<paragraph id="par_id3158313" role="paragraph" xml-lang="en-US">To spell out numbers in various number, currency and date formats, use a [NatNum12] modifier with the chosen arguments at the beginning of a number format code. See <link href="text/shared/01/05020301.xhp#NatNum12">NatNum12</link> section below.</paragraph> +<paragraph id="par_id3154600" role="paragraph" xml-lang="en-US">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 id="par_id3152546" role="example" localize="false" xml-lang="en-US">[NatNum1][$-411]0</paragraph> +<paragraph id="par_id3147269" role="paragraph" xml-lang="en-US">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 id="par_idN11234" role="paragraph" xml-lang="en-US">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 id="hd_id150820161449146058" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum0</emph>]</paragraph> +<paragraph id="par_id1508201614491484" role="paragraph" xml-lang="en-US">Try to convert any native number string to ASCII Arabic digits. If already ASCII, it remains ASCII.</paragraph> +<paragraph id="par_id13082016175325372" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum1</emph>]</paragraph> + +<table id="Table1"> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753258543" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016175325613" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753255045" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753252157" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753258910" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753252802" role="tablecontent" xml-lang="en-US">Chinese lower case characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753293296" role="tablecontent" localize="false" xml-lang="en-US">CAL: 1/7/7 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753293042" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753297854" role="tablecontent" xml-lang="en-US">short Kanji characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753295852" role="tablecontent" localize="false" xml-lang="en-US">[DBNum1]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753293652" role="tablecontent" localize="false" xml-lang="en-US">CAL: 1/4/4 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id13082016175330954" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753303188" role="tablecontent" xml-lang="en-US">Korean lower case characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753305557" role="tablecontent" localize="false" xml-lang="en-US">[DBNum1]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753303003" role="tablecontent" localize="false" xml-lang="en-US">CAL: 1/7/7 [DBNum1]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753317270" role="tablecontent" xml-lang="en-US">Hebrew</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753311497" role="tablecontent" xml-lang="en-US">Hebrew characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753301830" role="tablecontent" xml-lang="en-US">Arabic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753306722" role="tablecontent" xml-lang="en-US">Arabic-Indic characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753301290" role="tablecontent" xml-lang="en-US">Thai</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753301107" role="tablecontent" xml-lang="en-US">Thai characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753301831" role="tablecontent" xml-lang="en-US">Hindi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753306723" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753309518" role="tablecontent" xml-lang="en-US">Odia</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753301434" role="tablecontent" xml-lang="en-US">Odia (Oriya) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926246858" role="tablecontent" xml-lang="en-US">Marathi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926248586" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926241975" role="tablecontent" xml-lang="en-US">Bengali</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926246091" role="tablecontent" xml-lang="en-US">Bengali characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926256261" role="tablecontent" xml-lang="en-US">Punjabi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926257295" role="tablecontent" xml-lang="en-US">Punjabi (Gurmukhi) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926254282" role="tablecontent" xml-lang="en-US">Gujarati</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926258664" role="tablecontent" xml-lang="en-US">Gujarati characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192625454" role="tablecontent" xml-lang="en-US">Tamil</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926253837" role="tablecontent" xml-lang="en-US">Tamil characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192625217" role="tablecontent" xml-lang="en-US">Telugu</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192625475" role="tablecontent" xml-lang="en-US">Telugu characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926251185" role="tablecontent" xml-lang="en-US">Kannada</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192625183" role="tablecontent" xml-lang="en-US">Kannada characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926265921" role="tablecontent" xml-lang="en-US">Malayalam</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18082016192626103" role="tablecontent" xml-lang="en-US">Malayalam characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926264168" role="tablecontent" xml-lang="en-US">Lao</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926262520" role="tablecontent" xml-lang="en-US">Lao characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926264242" role="tablecontent" xml-lang="en-US">Tibetan</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926264284" role="tablecontent" xml-lang="en-US">Tibetan characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926265624" role="tablecontent" xml-lang="en-US">Burmese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926265398" role="tablecontent" xml-lang="en-US">Burmese (Myanmar) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926273825" role="tablecontent" xml-lang="en-US">Khmer</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926273240" role="tablecontent" xml-lang="en-US">Khmer (Cambodian) characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id18082016192627382" role="tablecontent" xml-lang="en-US">Mongolian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926276923" role="tablecontent" xml-lang="en-US">Mongolian characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926273435" role="tablecontent" xml-lang="en-US">Nepali</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926274450" role="tablecontent" xml-lang="en-US">Indic-Devanagari characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926279875" role="tablecontent" xml-lang="en-US">Dzongkha</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926276833" role="tablecontent" xml-lang="en-US">Tibetan characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926272903" role="tablecontent" xml-lang="en-US">Farsi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926271122" role="tablecontent" xml-lang="en-US">East Arabic-Indic characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926287716" role="tablecontent" xml-lang="en-US">Church Slavic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926281396" role="tablecontent" xml-lang="en-US">Cyrillic characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753318343" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum2</emph>]</paragraph> + +<table id="Tabela1"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101136589" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101139206" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016210113663" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id1308201621011376" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753314558" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753311211" role="tablecontent" xml-lang="en-US">Chinese upper case characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753316545" role="tablecontent" localize="false" xml-lang="en-US">CAL 2/8/8 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753311010" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753311215" role="tablecontent" xml-lang="en-US">traditional Kanji characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753315955" role="tablecontent" localize="false" xml-lang="en-US">CAL 2/5/5 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753315141" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753312451" role="tablecontent" xml-lang="en-US">Korean upper case characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753329118" role="tablecontent" localize="false" xml-lang="en-US">[DBNum2]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753323580" role="tablecontent" localize="false" xml-lang="en-US">CAL 2/8/8 [DBNum2]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id180820161926289664" role="tablecontent" xml-lang="en-US">Hebrew</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id180820161926288708" role="tablecontent" xml-lang="en-US">Hebrew numbering</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753325177" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum3</emph>]</paragraph> + +<table id="Tabela2"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101138131" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101133645" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101145252" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101147246" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753323484" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753325719" role="tablecontent" xml-lang="en-US">fullwidth Arabic digits</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753326476" role="tablecontent" localize="false" xml-lang="en-US">CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753327940" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753326195" role="tablecontent" xml-lang="en-US">fullwidth Arabic digits</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753323892" role="tablecontent" localize="false" xml-lang="en-US">CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753321617" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753332046" role="tablecontent" xml-lang="en-US">fullwidth Arabic digits</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753331134" role="tablecontent" localize="false" xml-lang="en-US">[DBNum3]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016175333654" role="tablecontent" localize="false" xml-lang="en-US">CAL: 3/3/3 [DBNum3]</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753334037" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum4</emph>]</paragraph> + +<table id="Tabela3"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101143647" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101148502" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016210114257" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101143643" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753333488" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753332509" role="tablecontent" xml-lang="en-US">lower case text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753332071" role="tablecontent" localize="false" xml-lang="en-US">[DBNum1]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753338548" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753332235" role="tablecontent" xml-lang="en-US">modern long Kanji text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753344875" role="tablecontent" localize="false" xml-lang="en-US">[DBNum2]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753349172" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753349817" role="tablecontent" xml-lang="en-US">formal lower case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753343499" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum5</emph>]</paragraph> + +<table id="Tabela4"> + <tablerow> + <tablecell> + <paragraph id="par_id13082016210114571" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101141303" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101143740" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016210114350" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753349058" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753342623" role="tablecontent" xml-lang="en-US">Chinese upper case text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753348999" role="tablecontent" localize="false" xml-lang="en-US">[DBNum2]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753347330" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753349141" role="tablecontent" xml-lang="en-US">traditional long Kanji text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016175334746" role="tablecontent" localize="false" xml-lang="en-US">[DBNum3]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753358520" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753353109" role="tablecontent" xml-lang="en-US">formal upper case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753358714" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum6</emph>]</paragraph> + +<table id="Tabela5"> + <tablerow> + <tablecell> + <paragraph id="par_id13082016210115753" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016210115453" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101151963" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101159516" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753355388" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753359335" role="tablecontent" xml-lang="en-US">fullwidth text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753351083" role="tablecontent" localize="false" xml-lang="en-US">[DBNum3]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753356656" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753358398" role="tablecontent" xml-lang="en-US">fullwidth text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753353657" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753365665" role="tablecontent" xml-lang="en-US">fullwidth text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753361819" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum7</emph>]</paragraph> + +<table id="Tabela6"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101152108" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101154544" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101159650" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101159955" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id150820161449152401" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id150820161449154907" role="tablecontent" xml-lang="en-US">short lower case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753365289" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753368507" role="tablecontent" xml-lang="en-US">modern short Kanji text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id13082016175336526" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016175336224" role="tablecontent" xml-lang="en-US">informal lower case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id13082016175336899" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum8</emph>]</paragraph> + +<table id="Tabela7"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101157872" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101157247" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101164630" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101163573" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id150820161449158539" role="tablecontent" xml-lang="en-US">Chinese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id150820161449151367" role="tablecontent" xml-lang="en-US">short upper case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753363281" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753366963" role="tablecontent" xml-lang="en-US">traditional short Kanji text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753361880" role="tablecontent" localize="false" xml-lang="en-US">[DBNum4]</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753376004" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753375830" role="tablecontent" xml-lang="en-US">informal upper case text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753378934" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum9</emph>]</paragraph> + +<table id="Tabela8"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101165923" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101164979" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101168382" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101167850" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753378980" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753375541" role="tablecontent" xml-lang="en-US">Hangul characters</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id130820161753379245" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum10</emph>]</paragraph> + +<table id="Tabela9"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101167963" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101164045" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101161811" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101167921" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161753374087" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753375766" role="tablecontent" xml-lang="en-US">formal Hangul text</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753372854" role="tablecontent" localize="false" xml-lang="en-US">[DBNum4]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161753372338" role="tablecontent" localize="false" xml-lang="en-US">CAL 9/11/11 [DBNum4]</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id13082016175338983" role="paragraph" localize="false" xml-lang="en-US">[<emph>NatNum11</emph>]</paragraph> + +<table id="Tabela10"> + <tablerow> + <tablecell> + <paragraph id="par_id130820162101165905" role="tablehead" xml-lang="en-US">Transliterations</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101173564" role="tablehead" xml-lang="en-US">Native Number Characters</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101175374" role="tablehead" localize="false" xml-lang="en-US">DBNumX</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820162101172644" role="tablehead" xml-lang="en-US">Date Format</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id13082016175338577" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016175338684" role="tablecontent" xml-lang="en-US">informal Hangul text</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + + +<section id="ExtendedLCID"> + +<paragraph id="hd_id231020161309281519" role="heading" level="3" xml-lang="en-US">Extended LCID</paragraph> +<paragraph id="par_id23102016124541451" role="paragraph" xml-lang="en-US">If compatible, native numbering and calendar are exported to Microsoft Excel using extended LCID. Extended LCID can also be used in string format instead of NatNum modifier.</paragraph> +<paragraph id="par_id23102016130928602" role="paragraph" xml-lang="en-US">Extended LCID consists of 8 hexadecimal digits: <emph>[$-NNCCLLLL]</emph>, with 2 first digits NN for native numerals, CC for calendar and LLLL for LCID code. For instance, <emph>[$-0D0741E]</emph> will be converted to <emph>[NatNum1][$-41E][~buddhist]</emph>: Thai numerals (0D) with Buddhist calendar (07) in Thai locale (041E).</paragraph> +<paragraph id="par_id231020161309295474" role="paragraph" xml-lang="en-US"><emph>Native Numerals</emph></paragraph> +<paragraph id="par_id231020161309291913" role="paragraph" xml-lang="en-US">Two first digits NN represents native numerals:</paragraph> + +<table id="tbl_23102016125042989"> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309383839" role="tablecontent" localize="false" xml-lang="en-US"><emph>NN</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309383870" role="tablecontent" xml-lang="en-US"><emph>Numeral</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309384878" role="tablecontent" xml-lang="en-US"><emph>Representation</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309389959" role="tablecontent" xml-lang="en-US"><emph>Compatible LCID</emph></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309399380" role="tablecontent" localize="false" xml-lang="en-US">01</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309391619" role="tablecontent" xml-lang="en-US">Arabic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309396637" role="tablecontent" localize="false" xml-lang="en-US">1234567890</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161309393242" role="tablecontent" xml-lang="en-US">all</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309398212" role="tablecontent" localize="false" xml-lang="en-US">02</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509387949" role="tablecontent" xml-lang="en-US">Eastern Arabic</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509384629" role="tablecontent" localize="false" xml-lang="en-US">١٢٣٤٥٦٧٨٩٠</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016150939771" role="tablecontent" localize="false" xml-lang="en-US">401</paragraph> + <paragraph id="par_id231020161509398304" role="tablecontent" localize="false" xml-lang="en-US">1401, 3c01, 0c01, 801, 2c01, 3401, 3001, 1001, 1801, 2001, 4001, 2801, 1c01, 3801, 2401</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id23102016130939725" role="tablecontent" localize="false" xml-lang="en-US">03</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509394713" role="tablecontent" xml-lang="en-US">Persian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509394097" role="tablecontent" localize="false" xml-lang="en-US">۱۲۳۴۵۶۷۸۹۰</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509396846" role="tablecontent" localize="false" xml-lang="en-US">429</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309408463" role="tablecontent" localize="false" xml-lang="en-US">04</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509397579" role="tablecontent" xml-lang="en-US">Devanagari</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509393579" role="tablecontent" localize="false" xml-lang="en-US">१२३४५६७८९०</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509391912" role="tablecontent" localize="false" xml-lang="en-US">439</paragraph> + <paragraph id="par_id231020161509405633" role="tablecontent" localize="false" xml-lang="en-US">44E, 461, 861</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309408346" role="tablecontent" localize="false" xml-lang="en-US">05</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509408164" role="tablecontent" xml-lang="en-US">Bengali</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509402887" role="tablecontent" localize="false" xml-lang="en-US">১২৩৪৫৬৭৮৯০</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509409038" role="tablecontent" localize="false" xml-lang="en-US">445</paragraph> + <paragraph id="par_id231020161509404604" role="tablecontent" localize="false" xml-lang="en-US">845</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309406290" role="tablecontent" localize="false" xml-lang="en-US">06</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509405793" role="tablecontent" xml-lang="en-US">Punjabi</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016150940241" role="tablecontent" localize="false" xml-lang="en-US">੧੨੩੪੫੬੭੮੯੦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509401607" role="tablecontent" localize="false" xml-lang="en-US">446</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309403229" role="tablecontent" localize="false" xml-lang="en-US">07</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509417889" role="tablecontent" xml-lang="en-US">Gujarati</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509418717" role="tablecontent" localize="false" xml-lang="en-US">૧૨૩૪૫૬૭૮૯૦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509418257" role="tablecontent" localize="false" xml-lang="en-US">447</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309406397" role="tablecontent" localize="false" xml-lang="en-US">08</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509417961" role="tablecontent" xml-lang="en-US">Oriya</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509415941" role="tablecontent" localize="false" xml-lang="en-US">୧୨୩୪୫୬୭୮୯୦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509412508" role="tablecontent" localize="false" xml-lang="en-US">448</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309401440" role="tablecontent" localize="false" xml-lang="en-US">09</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509428961" role="tablecontent" xml-lang="en-US">Tamil</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509413688" role="tablecontent" localize="false" xml-lang="en-US">௧௨௩௪௫௬௭௮௯0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509422594" role="tablecontent" localize="false" xml-lang="en-US">449</paragraph> + <paragraph id="par_id231020161509423511" role="tablecontent" localize="false" xml-lang="en-US">849</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309406637" role="tablecontent" localize="false" xml-lang="en-US">0A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509425901" role="tablecontent" xml-lang="en-US">Telugu</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509424675" role="tablecontent" localize="false" xml-lang="en-US">౧౨౩౪౫౬౭౮౯౦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509424950" role="tablecontent" localize="false" xml-lang="en-US">44A</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id23102016130940143" role="tablecontent" localize="false" xml-lang="en-US">0B</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509439802" role="tablecontent" xml-lang="en-US">Kannada</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509438337" role="tablecontent" localize="false" xml-lang="en-US">೧೨೩೪೫೬೭೮೯೦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509437941" role="tablecontent" localize="false" xml-lang="en-US">44B</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id23102016130940898" role="tablecontent" localize="false" xml-lang="en-US">0C</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509439635" role="tablecontent" xml-lang="en-US">Malayalam</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509438943" role="tablecontent" localize="false" xml-lang="en-US">൧൨൩൪൫൬൭൮൯൦</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509438875" role="tablecontent" localize="false" xml-lang="en-US">44C</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309412217" role="tablecontent" localize="false" xml-lang="en-US">0D</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509447377" role="tablecontent" xml-lang="en-US">Thai</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509435696" role="tablecontent" localize="false" xml-lang="en-US">๑๒๓๔๕๖๗๘๙๐</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509444294" role="tablecontent" localize="false" xml-lang="en-US">41E</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309414612" role="tablecontent" localize="false" xml-lang="en-US">0E</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509441865" role="tablecontent" xml-lang="en-US">Lao</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509441965" role="tablecontent" localize="false" xml-lang="en-US">໑໒໓໔໕໖໗໘໙໐</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509441336" role="tablecontent" localize="false" xml-lang="en-US">454</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id23102016130941180" role="tablecontent" localize="false" xml-lang="en-US">0F</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509453645" role="tablecontent" xml-lang="en-US">Tibetan</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509445565" role="tablecontent" localize="false" xml-lang="en-US">༡༢༣༤༥༦༧༨༩༠</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509453146" role="tablecontent" localize="false" xml-lang="en-US">851</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309419644" role="tablecontent" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509455556" role="tablecontent" xml-lang="en-US">Burmese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509459048" role="tablecontent" localize="false" xml-lang="en-US">၁၂၃၄၅၆၇၈၉၀</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509451064" role="tablecontent" localize="false" xml-lang="en-US">455</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309411926" role="tablecontent" localize="false" xml-lang="en-US">11</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509468188" role="tablecontent" xml-lang="en-US">Tigrina</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509468954" role="tablecontent" localize="false" xml-lang="en-US">፩፪፫፬፭፮፯፰፱0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509469791" role="tablecontent" localize="false" xml-lang="en-US">473</paragraph> + <paragraph id="par_id2310201615094683" role="tablecontent" localize="false" xml-lang="en-US">873</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309411348" role="tablecontent" localize="false" xml-lang="en-US">12</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509467357" role="tablecontent" xml-lang="en-US">Khmer</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509461064" role="tablecontent" localize="false" xml-lang="en-US">១២៣៤៥៦៧៨៩០</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509479092" role="tablecontent" localize="false" xml-lang="en-US">453</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309414613" role="tablecontent" localize="false" xml-lang="en-US">13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509473329" role="tablecontent" xml-lang="en-US">Mongolian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509477869" role="tablecontent" localize="false" xml-lang="en-US">᠑᠒᠓᠔᠕᠖᠗᠘᠙᠐</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509476436" role="tablecontent" localize="false" xml-lang="en-US">C50</paragraph> + <paragraph id="par_id231020161509475815" role="tablecontent" localize="false" xml-lang="en-US">850</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309413615" role="tablecontent" localize="false" xml-lang="en-US">1B</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509481466" role="tablecontent" xml-lang="en-US">Japanese</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509473141" role="tablecontent" localize="false" xml-lang="en-US">一二三四五六七八九〇</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509488271" role="tablecontent" localize="false" xml-lang="en-US">411</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309418123" role="tablecontent" localize="false" xml-lang="en-US">1C</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656391202" role="tablecontent" xml-lang="en-US">(financial)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509484357" role="tablecontent" localize="false" xml-lang="en-US">壱弐参四伍六七八九〇</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309425570" role="tablecontent" localize="false" xml-lang="en-US">1D</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656429927" role="tablecontent" xml-lang="en-US">(fullwidth Arabic)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509591467" role="tablecontent" localize="false" xml-lang="en-US">１２３４５６７８９０</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309424572" role="tablecontent" localize="false" xml-lang="en-US">1E</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509594133" role="tablecontent" xml-lang="en-US">Chinese - simplified</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509596356" role="tablecontent" localize="false" xml-lang="en-US">一二三四五六七八九○</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509597132" role="tablecontent" localize="false" xml-lang="en-US">804</paragraph> + <paragraph id="par_id231020161509598575" role="tablecontent" localize="false" xml-lang="en-US">1004, 7804</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309425717" role="tablecontent" localize="false" xml-lang="en-US">1F</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656421782" role="tablecontent" xml-lang="en-US">(financial)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161509596391" role="tablecontent" localize="false" xml-lang="en-US">壹贰叁肆伍陆柒捌玖零</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309423375" role="tablecontent" localize="false" xml-lang="en-US">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656426120" role="tablecontent" xml-lang="en-US">(fullwidth Arabic)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510005629" role="tablecontent" localize="false" xml-lang="en-US">１２３４５６７８９０</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309422191" role="tablecontent" localize="false" xml-lang="en-US">21</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510005692" role="tablecontent" xml-lang="en-US">Chinese - traditional</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510003302" role="tablecontent" localize="false" xml-lang="en-US">一二三四五六七八九○</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510009924" role="tablecontent" localize="false" xml-lang="en-US">C04</paragraph> + <paragraph id="par_id231020161510002085" role="tablecontent" localize="false" xml-lang="en-US">1404</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309422076" role="tablecontent" localize="false" xml-lang="en-US">22</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656435830" role="tablecontent" xml-lang="en-US">(financial)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510008728" role="tablecontent" localize="false" xml-lang="en-US">壹貳參肆伍陸柒捌玖零</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309421288" role="tablecontent" localize="false" xml-lang="en-US">23</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656439568" role="tablecontent" xml-lang="en-US">(fullwidth Arabic)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510005585" role="tablecontent" localize="false" xml-lang="en-US">１２３４５６７８９０</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309428559" role="tablecontent" localize="false" xml-lang="en-US">24</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510017298" role="tablecontent" xml-lang="en-US">Korean</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510014281" role="tablecontent" localize="false" xml-lang="en-US">一二三四五六七八九０</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510016183" role="tablecontent" localize="false" xml-lang="en-US">812</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309427580" role="tablecontent" localize="false" xml-lang="en-US">25</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656436379" role="tablecontent" xml-lang="en-US">(financial)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510017956" role="tablecontent" localize="false" xml-lang="en-US">壹貳參四伍六七八九零</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309421953" role="tablecontent" localize="false" xml-lang="en-US">26</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161656438773" role="tablecontent" xml-lang="en-US">(fullwidth Arabic)</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016151001163" role="tablecontent" localize="false" xml-lang="en-US">１２３４５６７８９０</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161309436961" role="tablecontent" localize="false" xml-lang="en-US">27</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510026939" role="tablecontent" xml-lang="en-US">Korean - Hangul</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510017167" role="tablecontent" localize="false" xml-lang="en-US">일이삼사오육칠팔구영</paragraph> + </tablecell> + <tablecell> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id231020161510022383" role="paragraph" xml-lang="en-US"><emph>Calendar</emph></paragraph> +<paragraph id="par_id231020161510021223" role="paragraph" xml-lang="en-US">Two next digits CC are for calendar code. Each calendar is only valid for some LCID.</paragraph> + +<table id="tbl_23102016144703190"> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510028115" role="tablecontent" localize="false" xml-lang="en-US"><emph>CC</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510022813" role="tablecontent" xml-lang="en-US"><emph>Calendar</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510028097" role="tablecontent" xml-lang="en-US"><emph>Example (YYYY-MM-DD)</emph></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510025567" role="tablecontent" xml-lang="en-US"><emph>Supported LCID</emph></paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510032677" role="tablecontent" localize="false" xml-lang="en-US">00</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510038464" role="tablecontent" xml-lang="en-US">Gregorian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510032564" role="tablecontent" localize="false" xml-lang="en-US">2016-08-31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510032619" role="tablecontent" xml-lang="en-US">All</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510033349" role="tablecontent" localize="false" xml-lang="en-US">03</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510037287" role="tablecontent" xml-lang="en-US">Gengou</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510035843" role="tablecontent" localize="false" xml-lang="en-US">28-08-31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510041970" role="tablecontent" xml-lang="en-US">411 (Japanese)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510044812" role="tablecontent" localize="false" xml-lang="en-US">05</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510049706" role="tablecontent" xml-lang="en-US">Unknown</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510042281" role="tablecontent" localize="false" xml-lang="en-US">4349-08-31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510047856" role="tablecontent" xml-lang="en-US">Unsupported</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510048032" role="tablecontent" xml-lang="en-US">06 or 17</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510056158" role="tablecontent" xml-lang="en-US">Hijri</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510059401" role="tablecontent" localize="false" xml-lang="en-US">1437-11-28</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510052682" role="tablecontent" xml-lang="en-US">401 (Arabic - Saudi Arabia), 1401 (Arabic - Algeria), 3c01 (Arabic - Bahrain), 0c01 (Arabic - Egypt), 801 (Arabic - Iraq), 2c01 (Arabic - Jordan), 3401 (Arabic - Kuwait), 3001 (Arabic - Lebanon), 1001 (Arabic - Libya), 1801 (Arabic - Morocco), 2001 (Arabic - Oman), 4001 (Arabic - Qatar), 2801 (Arabic - Syria), 1c01 (Arabic - Tunisia), 3801 (Arabic - U.A.E.), 2401 (Arabic - Yemen) and 429 (Farsi)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510052179" role="tablecontent" localize="false" xml-lang="en-US">07</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2310201615100511" role="tablecontent" xml-lang="en-US">Buddhist</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016151005607" role="tablecontent" localize="false" xml-lang="en-US">2559-08-31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510059823" role="tablecontent" xml-lang="en-US">454 (Lao), 41E (Thai)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510065954" role="tablecontent" localize="false" xml-lang="en-US">08</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510061354" role="tablecontent" xml-lang="en-US">Jewish</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510062369" role="tablecontent" localize="false" xml-lang="en-US">5776-05-27</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510065493" role="tablecontent" xml-lang="en-US">40D (Hebrew)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2310201615100635" role="tablecontent" localize="false" xml-lang="en-US">10</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510062635" role="tablecontent" xml-lang="en-US">Indian</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016151007630" role="tablecontent" localize="false" xml-lang="en-US">1938-06-09</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23102016151007443" role="tablecontent" xml-lang="en-US">Unsupported</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510074383" role="tablecontent" xml-lang="en-US">0E, 0F, 11, 12 or 13</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510072324" role="tablecontent" xml-lang="en-US">Unknown</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510071869" role="tablecontent" localize="false" xml-lang="en-US">2016-07-29</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510079549" role="tablecontent" xml-lang="en-US">Unsupported</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510074993" role="tablecontent" xml-lang="en-US">Unsupported</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510086169" role="tablecontent" xml-lang="en-US">Hanja</paragraph> + </tablecell> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id23102016151008696" role="tablecontent" xml-lang="en-US">412 (Korean)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id231020161510087847" role="tablecontent" xml-lang="en-US">Unsupported</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510081946" role="tablecontent" xml-lang="en-US">ROC</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510089684" role="tablecontent" localize="false" xml-lang="en-US">0105-08-31</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id231020161510088509" role="tablecontent" xml-lang="en-US">404 (Chinese - Taiwan)</paragraph> + </tablecell> + </tablerow> +</table> +</section> + +<section id="NatNum12"> + +<paragraph id="hd_id231201610928993199" role="heading" level="2" xml-lang="en-US">NatNum12 modifier</paragraph> + +<paragraph id="par_id3158314" role="paragraph" xml-lang="en-US">To spell out numbers in various number, currency and date formats, use a [NatNum12] modifier with the chosen arguments at the beginning of a number format code.</paragraph> + +<paragraph id="par_id130820161735318343" role="paragraph" xml-lang="en-US">Common NatNum12 formatting examples</paragraph> + +<table id="Tabela101"> + <tablerow> + <tablecell> + <paragraph id="par_id130820131011365891" role="tablehead" xml-lang="en-US">Formatting code</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016201136632" role="tablehead" xml-lang="en-US">Explanation</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id130820161733145583" role="tablecontent" xml-lang="en-US">[NatNum12]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161733112114" role="tablecontent" xml-lang="en-US">Spell out as cardinal number: 1 → one</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617533145585" role="tablecontent" xml-lang="en-US">[NatNum12 ordinal]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016107533112116" role="tablecontent" xml-lang="en-US">Spell out as ordinal number: 1 → first</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201616533145587" role="tablecontent" xml-lang="en-US">[NatNum12 ordinal-number]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016107533112118" role="tablecontent" xml-lang="en-US">Spell out as ordinal indicator: 1 → 1st</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201796533145589" role="tablecontent" xml-lang="en-US">[NatNum12 capitalize]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130820161715331121110" role="tablecontent" xml-lang="en-US">Spell out with capitalization, as cardinal number: 1 → One</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455812" role="tablecontent" xml-lang="en-US">[NatNum12 upper ordinal]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id130826171075331121112" role="tablecontent" xml-lang="en-US">Spell out in upper case, as ordinal number: 1 → FIRST</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455813" role="tablecontent" xml-lang="en-US">[NatNum12 title]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121114" role="tablecontent" xml-lang="en-US">Spell out in title case, as cardinal number: 101 → Hundred One</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455814" role="tablecontent" xml-lang="en-US">[NatNum12 USD]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121115" role="tablecontent" xml-lang="en-US">Spell out as a money amount of a given currency specified by 3-letter ISO code: 1 → one U.S. dollar</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455816" role="tablecontent" xml-lang="en-US">[NatNum12 D=ordinal-number]D" of "MMMM</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121117" role="tablecontent" xml-lang="en-US">Spell out as a date in format "1st of May"</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455818" role="tablecontent" xml-lang="en-US">[NatNum12 YYYY=title year,D=capitalize ordinal]D" of "MMMM, YYYY</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121119" role="tablecontent" xml-lang="en-US">Spell out as a date in format "First of May, Nineteen Ninety-nine"</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455819" role="tablecontent" xml-lang="en-US">[NatNum12 MMM=upper]MMM-DD</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121120" role="tablecontent" xml-lang="en-US">Display upper case abbreviated month name in format "JAN-01"</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id1308201617965331455820" role="tablecontent" xml-lang="en-US">[NatNum12 MMMM=lower]MMMM</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id13082016075331121121" role="tablecontent" xml-lang="en-US">Display lower case month name in format "january"</paragraph> + </tablecell> + </tablerow> +</table> + +<paragraph id="par_id3158316" role="paragraph" xml-lang="en-US">Other possible arguments: "money" before 3-letter currency codes, for example [NatNum12 capitalize money USD]0.00 will format number "1.99" as "One and 99/100 U.S. Dollars".</paragraph> + +</section> + +<section id="ErrorCodes"> + +<paragraph id="hd_id231201610928993200" role="heading" level="2" xml-lang="en-US">Error Codes</paragraph> + +<paragraph id="par_id3158315" role="paragraph" xml-lang="en-US">If the value is outside the limits for the selected format the following error code is shown:</paragraph> + +<paragraph id="par_id3158316" role="code" localize="false" xml-lang="en-US">#FMT</paragraph> + +</section> + +</body> +</helpdocument> |