1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3c63dc91bSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 5c63dc91bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 6c63dc91bSAndrew Rist * or more contributor license agreements. See the NOTICE file 7c63dc91bSAndrew Rist * distributed with this work for additional information 8c63dc91bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 9c63dc91bSAndrew Rist * to you under the Apache License, Version 2.0 (the 10c63dc91bSAndrew Rist * "License"); you may not use this file except in compliance 11c63dc91bSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 13c63dc91bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 15c63dc91bSAndrew Rist * Unless required by applicable law or agreed to in writing, 16c63dc91bSAndrew Rist * software distributed under the License is distributed on an 17c63dc91bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18c63dc91bSAndrew Rist * KIND, either express or implied. See the License for the 19c63dc91bSAndrew Rist * specific language governing permissions and limitations 20c63dc91bSAndrew Rist * under the License. 21cdf0e10cSrcweir * 22c63dc91bSAndrew Rist ***********************************************************--> 23c63dc91bSAndrew Rist 24d1c38b03Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textshared0105020301xml" indexer="include"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Number Format Codes</title> 28cdf0e10cSrcweir<filename>/text/shared/01/05020301.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 3282a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153514"> 3382a98929Smseidel<bookmark_value>format codes; numbers</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>conditions; in number formats</bookmark_value> 35cdf0e10cSrcweir<bookmark_value>number formats; codes</bookmark_value> 36cdf0e10cSrcweir<bookmark_value>currency formats</bookmark_value> 37cdf0e10cSrcweir<bookmark_value>formats;of currencies/date/time</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>numbers; date, time and currency formats</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>Euro; currency formats</bookmark_value> 40cdf0e10cSrcweir<bookmark_value>date formats</bookmark_value> 41cdf0e10cSrcweir<bookmark_value>times, formats</bookmark_value> 42cdf0e10cSrcweir</bookmark><comment>mw made "time formats" a two level entry and deleted 2x "formats;"</comment> 4380b082deSmseidel<paragraph role="heading" id="hd_id3153514" xml-lang="en-US" level="1" l10n="U"><variable id="zahlenformatcodes"><link href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format Codes</link> 44cdf0e10cSrcweir</variable></paragraph> 4580b082deSmseidel<paragraph role="paragraph" id="par_id3150467" xml-lang="en-US" l10n="U">Number format codes can consist of up to three sections separated by a semicolon (;).</paragraph> 46cdf0e10cSrcweir<list type="ordered"> 47cdf0e10cSrcweir<listitem> 48*347184d5Smseidel<paragraph role="listitem" id="par_id3150146" xml-lang="en-US" l10n="U">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> 49cdf0e10cSrcweir</listitem> 50cdf0e10cSrcweir<listitem> 51*347184d5Smseidel<paragraph role="listitem" id="par_id3158442" xml-lang="en-US" l10n="CHG">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> 52cdf0e10cSrcweir</listitem> 53cdf0e10cSrcweir</list> 54cdf0e10cSrcweir<list type="ordered"> 55cdf0e10cSrcweir<listitem> 56*347184d5Smseidel<paragraph role="listitem" id="par_id3155069" xml-lang="en-US" l10n="U">You can also assign conditions to the three sections, so that the format is only applied if a condition is met.</paragraph> 57cdf0e10cSrcweir</listitem> 58cdf0e10cSrcweir</list> 59*347184d5Smseidel<paragraph role="heading" id="hd_id3151262" xml-lang="en-US" level="2" l10n="U">Decimal Places and Significant Digits</paragraph> 6080b082deSmseidel<paragraph role="paragraph" id="par_id3153624" xml-lang="en-US" l10n="U">Use zero (0) or the number sign (#) as placeholders in your number format code to represent numbers. The (#) only displays significant digits, while the (0) displays zeroes if there are fewer digits in the number than in the number format.</paragraph> 61*347184d5Smseidel<paragraph role="paragraph" id="par_id3153323" xml-lang="en-US" l10n="U">Use question marks (?) to represent the number of digits to include in the numerator and the denominator of a fraction. Fractions that do not fit the pattern that you define are displayed as floating point numbers.</paragraph> 6280b082deSmseidel<paragraph role="paragraph" id="par_id3148440" xml-lang="en-US" l10n="U">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> 63cdf0e10cSrcweir<table id="tbl_id3149760"> 64cdf0e10cSrcweir<tablerow> 65cdf0e10cSrcweir<tablecell> 6680b082deSmseidel<paragraph role="tablehead" id="par_id3150902" xml-lang="en-US" l10n="U">Placeholders</paragraph> 67cdf0e10cSrcweir</tablecell> 68cdf0e10cSrcweir<tablecell> 6980b082deSmseidel<paragraph role="tablehead" id="par_id3157896" xml-lang="en-US" l10n="U">Explanation</paragraph> 70cdf0e10cSrcweir</tablecell> 71cdf0e10cSrcweir</tablerow> 72cdf0e10cSrcweir<tablerow> 73cdf0e10cSrcweir<tablecell> 7480b082deSmseidel<paragraph role="code" id="par_id3152801" xml-lang="en-US" l10n="U">#</paragraph> 75cdf0e10cSrcweir</tablecell> 76cdf0e10cSrcweir<tablecell> 7780b082deSmseidel<paragraph role="tablecontent" id="par_id3145090" xml-lang="en-US" l10n="U">Does not display extra zeros.</paragraph> 78cdf0e10cSrcweir</tablecell> 79cdf0e10cSrcweir</tablerow> 80cdf0e10cSrcweir<tablerow> 81cdf0e10cSrcweir<tablecell> 8280b082deSmseidel<paragraph role="code" id="par_id3147088" xml-lang="en-US" l10n="U">0 (Zero)</paragraph> 83cdf0e10cSrcweir</tablecell> 84cdf0e10cSrcweir<tablecell> 8580b082deSmseidel<paragraph role="tablecontent" id="par_id3150774" xml-lang="en-US" l10n="U">Displays extra zeros if the number has less places than zeros in the format.</paragraph> 86cdf0e10cSrcweir</tablecell> 87cdf0e10cSrcweir</tablerow> 88cdf0e10cSrcweir</table> 89cdf0e10cSrcweir<paragraph role="heading" id="par_idN1087E" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph> 90cdf0e10cSrcweir<table id="tbl_id3153577"> 91cdf0e10cSrcweir<tablerow> 92cdf0e10cSrcweir<tablecell> 9380b082deSmseidel<paragraph role="tablehead" id="par_id3149182" xml-lang="en-US" l10n="U">Number Format</paragraph> 94cdf0e10cSrcweir</tablecell> 95cdf0e10cSrcweir<tablecell> 9680b082deSmseidel<paragraph role="tablehead" id="par_id3154749" xml-lang="en-US" l10n="U">Format Code</paragraph> 97cdf0e10cSrcweir</tablecell> 98cdf0e10cSrcweir</tablerow> 99cdf0e10cSrcweir<tablerow> 100cdf0e10cSrcweir<tablecell> 10180b082deSmseidel<paragraph role="tablecontent" id="par_id3148538" xml-lang="en-US" l10n="U">3456.78 as 3456.8</paragraph> 102cdf0e10cSrcweir</tablecell> 103cdf0e10cSrcweir<tablecell> 10480b082deSmseidel<paragraph role="code" id="par_id3150355" xml-lang="en-US" l10n="U">####.#</paragraph> 105cdf0e10cSrcweir</tablecell> 106cdf0e10cSrcweir</tablerow> 107cdf0e10cSrcweir<tablerow> 108cdf0e10cSrcweir<tablecell> 10980b082deSmseidel<paragraph role="tablecontent" id="par_id3154142" xml-lang="en-US" l10n="U">9.9 as 9.900</paragraph> 110cdf0e10cSrcweir</tablecell> 111cdf0e10cSrcweir<tablecell> 11280b082deSmseidel<paragraph role="code" id="par_id3159256" xml-lang="en-US" l10n="U">#.000</paragraph> 113cdf0e10cSrcweir</tablecell> 114cdf0e10cSrcweir</tablerow> 115cdf0e10cSrcweir<tablerow> 116cdf0e10cSrcweir<tablecell> 11780b082deSmseidel<paragraph role="tablecontent" id="par_id3147077" xml-lang="en-US" l10n="U">13 as 13.0 and 1234.567 as 1234.57</paragraph> 118cdf0e10cSrcweir</tablecell> 119cdf0e10cSrcweir<tablecell> 12080b082deSmseidel<paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U">#.0#</paragraph> 121cdf0e10cSrcweir</tablecell> 122cdf0e10cSrcweir</tablerow> 123cdf0e10cSrcweir<tablerow> 124cdf0e10cSrcweir<tablecell> 12580b082deSmseidel<paragraph role="tablecontent" id="par_id3149578" xml-lang="en-US" l10n="U">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph> 126cdf0e10cSrcweir</tablecell> 127cdf0e10cSrcweir<tablecell> 12880b082deSmseidel<paragraph role="code" id="par_id3145315" xml-lang="en-US" l10n="U"># ???/???</paragraph> 129cdf0e10cSrcweir</tablecell> 130cdf0e10cSrcweir</tablerow> 131cdf0e10cSrcweir<tablerow> 132cdf0e10cSrcweir<tablecell> 13380b082deSmseidel<paragraph role="tablecontent" id="par_id3156152" xml-lang="en-US" l10n="U">.5 as 0.5</paragraph> 134cdf0e10cSrcweir</tablecell> 135cdf0e10cSrcweir<tablecell> 13680b082deSmseidel<paragraph role="code" id="par_id3149762" xml-lang="en-US" l10n="U">0.##</paragraph> 137cdf0e10cSrcweir</tablecell> 138cdf0e10cSrcweir</tablerow> 139cdf0e10cSrcweir</table> 140*347184d5Smseidel<paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3" l10n="U">Thousands Separator</paragraph> 14180b082deSmseidel<paragraph role="paragraph" id="par_id3154380" xml-lang="en-US" l10n="U">Depending on your language setting, you can use a comma or a period as a thousands separator. You can also use the separator to reduce the size of the number that is displayed by a multiple of 1000.</paragraph> 142cdf0e10cSrcweir<table id="tbl_id3150244"> 143cdf0e10cSrcweir<tablerow> 144cdf0e10cSrcweir<tablecell> 14580b082deSmseidel<paragraph role="tablehead" id="par_id3154905" xml-lang="en-US" l10n="U">Number Format</paragraph> 146cdf0e10cSrcweir</tablecell> 147cdf0e10cSrcweir<tablecell> 14880b082deSmseidel<paragraph role="tablehead" id="par_id3150822" xml-lang="en-US" l10n="U">Format Code</paragraph> 149cdf0e10cSrcweir</tablecell> 150cdf0e10cSrcweir</tablerow> 151cdf0e10cSrcweir<tablerow> 152cdf0e10cSrcweir<tablecell> 15380b082deSmseidel<paragraph role="tablecontent" id="par_id3147264" xml-lang="en-US" l10n="U">15000 as 15,000</paragraph> 154cdf0e10cSrcweir</tablecell> 155cdf0e10cSrcweir<tablecell> 15680b082deSmseidel<paragraph role="code" id="par_id3151223" xml-lang="en-US" l10n="U">#,###</paragraph> 157cdf0e10cSrcweir</tablecell> 158cdf0e10cSrcweir</tablerow> 159cdf0e10cSrcweir<tablerow> 160cdf0e10cSrcweir<tablecell> 16180b082deSmseidel<paragraph role="tablecontent" id="par_id3154935" xml-lang="en-US" l10n="U">16000 as 16</paragraph> 162cdf0e10cSrcweir</tablecell> 163cdf0e10cSrcweir<tablecell> 16480b082deSmseidel<paragraph role="code" id="par_id3153961" xml-lang="en-US" l10n="U">#,</paragraph> 165cdf0e10cSrcweir</tablecell> 166cdf0e10cSrcweir</tablerow> 167cdf0e10cSrcweir</table> 16880b082deSmseidel<paragraph role="heading" id="hd_id3154836" xml-lang="en-US" level="2" l10n="U">Including Text in Number Format Codes</paragraph> 169*347184d5Smseidel<paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="3" l10n="U">Text and Numbers</paragraph> 17080b082deSmseidel<paragraph role="paragraph" id="par_id3154224" xml-lang="en-US" l10n="U">To include text in a number format that is applied to a cell containing numbers, place a double quotation mark (") in front of and behind the text, or a backslash (\) before a single character. For example, enter <emph>#.# "meters"</emph> to display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m".</paragraph> 171*347184d5Smseidel<paragraph role="heading" id="hd_id3148979" xml-lang="en-US" level="3" l10n="U">Text and Text</paragraph> 17280b082deSmseidel<paragraph role="paragraph" id="par_id3153338" xml-lang="en-US" l10n="U">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> 173*347184d5Smseidel<paragraph role="heading" id="hd_id3154330" xml-lang="en-US" level="3" l10n="U">Spaces</paragraph> 17480b082deSmseidel<paragraph role="paragraph" id="par_id3156294" xml-lang="en-US" l10n="U">To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, <emph>_M</emph> creates a wider space than <emph>_i</emph>.</paragraph> 175*347184d5Smseidel<paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="2" l10n="U">Color</paragraph> 17680b082deSmseidel<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U">To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]:</paragraph> 177cdf0e10cSrcweir<table id="tbl_id3157321"> 178cdf0e10cSrcweir<tablerow> 179cdf0e10cSrcweir<tablecell> 18080b082deSmseidel<paragraph role="code" id="par_id3154630" xml-lang="en-US" l10n="U">CYAN</paragraph> 181cdf0e10cSrcweir</tablecell> 182cdf0e10cSrcweir<tablecell> 18380b082deSmseidel<paragraph role="code" id="par_id3148676" xml-lang="en-US" l10n="U">GREEN</paragraph> 184cdf0e10cSrcweir</tablecell> 185cdf0e10cSrcweir</tablerow> 186cdf0e10cSrcweir<tablerow> 187cdf0e10cSrcweir<tablecell> 18880b082deSmseidel<paragraph role="code" id="par_id3154123" xml-lang="en-US" l10n="U">BLACK</paragraph> 189cdf0e10cSrcweir</tablecell> 190cdf0e10cSrcweir<tablecell> 19180b082deSmseidel<paragraph role="code" id="par_id3149167" xml-lang="en-US" l10n="U">BLUE</paragraph> 192cdf0e10cSrcweir</tablecell> 193cdf0e10cSrcweir</tablerow> 194cdf0e10cSrcweir<tablerow> 195cdf0e10cSrcweir<tablecell> 19680b082deSmseidel<paragraph role="code" id="par_id3158407" xml-lang="en-US" l10n="U">MAGENTA</paragraph> 197cdf0e10cSrcweir</tablecell> 198cdf0e10cSrcweir<tablecell> 19980b082deSmseidel<paragraph role="code" id="par_id3149560" xml-lang="en-US" l10n="U">RED</paragraph> 200cdf0e10cSrcweir</tablecell> 201cdf0e10cSrcweir</tablerow> 202cdf0e10cSrcweir<tablerow> 203cdf0e10cSrcweir<tablecell> 20480b082deSmseidel<paragraph role="code" id="par_id3147502" xml-lang="en-US" l10n="U">WHITE</paragraph> 205cdf0e10cSrcweir</tablecell> 206cdf0e10cSrcweir<tablecell> 20780b082deSmseidel<paragraph role="code" id="par_id3153368" xml-lang="en-US" l10n="U">YELLOW</paragraph> 208cdf0e10cSrcweir</tablecell> 209cdf0e10cSrcweir</tablerow> 210cdf0e10cSrcweir</table> 211*347184d5Smseidel<paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2" l10n="U">Conditions</paragraph> 212*347184d5Smseidel<paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="3" l10n="U">Conditional Brackets</paragraph> 213*347184d5Smseidel<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U">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> 214*347184d5Smseidel<paragraph role="paragraph" id="par_id3159179" xml-lang="en-US" l10n="U">You can use any combination of numbers and the <, <=, >, >=, = and <> operators.</paragraph> 215*347184d5Smseidel<paragraph role="paragraph" id="par_id3159196" xml-lang="en-US" l10n="U">For example, if you want to apply different colors to different temperature data, enter:</paragraph> 216*347184d5Smseidel<paragraph role="example" id="par_id3150872" xml-lang="en-US" l10n="U">[BLUE][<0]#,0 "°C";[RED][>30]#,0 "°C";[BLACK]#,0 "°C"</paragraph> 217*347184d5Smseidel<paragraph role="paragraph" id="par_id3157870" xml-lang="en-US" l10n="U">All temperatures below zero are blue, temperatures between 0 and 30 °C are black, and temperatures higher than 30 °C are red.</paragraph> 21880b082deSmseidel<paragraph role="heading" id="hd_id3154833" xml-lang="en-US" level="3" l10n="U">Positive and Negative Numbers</paragraph> 21980b082deSmseidel<paragraph role="paragraph" id="par_id3147295" xml-lang="en-US" l10n="U">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> 22080b082deSmseidel<paragraph role="example" id="par_id3153727" xml-lang="en-US" l10n="U">"plus" 0;"minus" 0;"null" 0</paragraph> 22180b082deSmseidel<paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2" l10n="U">Percentages and Scientific Notation</paragraph> 222*347184d5Smseidel<paragraph role="heading" id="hd_id3147218" xml-lang="en-US" level="3" l10n="U">Percentages</paragraph> 22380b082deSmseidel<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="CHG">To display numbers as percentages, add the percent sign (%) to the number format.</paragraph> 22480b082deSmseidel<paragraph role="heading" id="hd_id3156005" xml-lang="en-US" level="3" l10n="U">Scientific Notation</paragraph> 22580b082deSmseidel<paragraph role="paragraph" id="par_id3146923" xml-lang="en-US" l10n="U">Scientific notation lets you write very large numbers or very small fractions in a compact form. For example, in scientific notation, 650000 is written as 6.5 x 10^5, and 0.000065 as 6.5 x 10^-5. <comment>Translators: use the decimal delimiter of your language (period or comma) for all number format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>, these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that displays numbers using scientific notation, enter a # or 0, and then one of the following codes E-, E+, e- or e+.</paragraph> 22680b082deSmseidel<paragraph role="heading" id="hd_id3159080" xml-lang="en-US" level="2" l10n="U">Number Format Codes of Currency Formats</paragraph> 22780b082deSmseidel<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="CHG">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> 228*347184d5Smseidel<paragraph role="paragraph" id="par_id3150032" xml-lang="en-US" l10n="U">You can also specify the locale setting for the currency by entering the locale code for the country after the symbol. For example, [$€-407] represents Euros in Germany. To view the locale code for a country, select the country in the <emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format Cells</emph> dialog.</paragraph> 229cdf0e10cSrcweir<embed href="text/shared/01/05020300.xhp#waehrungtext"/> 230*347184d5Smseidel<paragraph role="heading" id="hd_id3157309" xml-lang="en-US" level="2" l10n="U">Date and Time Formats</paragraph> 23180b082deSmseidel<paragraph role="heading" id="hd_id3153740" xml-lang="en-US" level="3" l10n="U">Date Formats</paragraph> 23280b082deSmseidel<paragraph role="paragraph" id="par_id3152791" xml-lang="en-US" l10n="U">To display days, months and years, use the following number format codes.</paragraph> 233cdf0e10cSrcweir<paragraph role="warning" id="par_id610980" xml-lang="en-US" l10n="NEW">Not all format codes give meaningful results for all languages.</paragraph> 234cdf0e10cSrcweir<table id="tbl_id3147426"> 235cdf0e10cSrcweir<tablerow> 236cdf0e10cSrcweir<tablecell> 23780b082deSmseidel<paragraph role="tablehead" id="par_id3152376" xml-lang="en-US" l10n="U">Format</paragraph> 238cdf0e10cSrcweir</tablecell> 239cdf0e10cSrcweir<tablecell> 24080b082deSmseidel<paragraph role="tablehead" id="par_id3159130" xml-lang="en-US" l10n="U">Format Code</paragraph> 241cdf0e10cSrcweir</tablecell> 242cdf0e10cSrcweir</tablerow> 243cdf0e10cSrcweir<tablerow> 244cdf0e10cSrcweir<tablecell> 24580b082deSmseidel<paragraph role="tablecontent" id="par_id3147380" xml-lang="en-US" l10n="U">Month as 3.</paragraph> 246cdf0e10cSrcweir</tablecell> 247cdf0e10cSrcweir<tablecell> 24880b082deSmseidel<paragraph role="code" id="par_id3146928" xml-lang="en-US" l10n="U">M</paragraph> 249cdf0e10cSrcweir</tablecell> 250cdf0e10cSrcweir</tablerow> 251cdf0e10cSrcweir<tablerow> 252cdf0e10cSrcweir<tablecell> 25380b082deSmseidel<paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U">Month as 03.</paragraph> 254cdf0e10cSrcweir</tablecell> 255cdf0e10cSrcweir<tablecell> 25680b082deSmseidel<paragraph role="code" id="par_id3153052" xml-lang="en-US" l10n="U">MM</paragraph> 257cdf0e10cSrcweir</tablecell> 258cdf0e10cSrcweir</tablerow> 259cdf0e10cSrcweir<tablerow> 260cdf0e10cSrcweir<tablecell> 26180b082deSmseidel<paragraph role="tablecontent" id="par_id3145728" xml-lang="en-US" l10n="U">Month as Jan-Dec</paragraph> 262cdf0e10cSrcweir</tablecell> 263cdf0e10cSrcweir<tablecell> 26480b082deSmseidel<paragraph role="code" id="par_id3151073" xml-lang="en-US" l10n="U">MMM</paragraph> 265cdf0e10cSrcweir</tablecell> 266cdf0e10cSrcweir</tablerow> 267cdf0e10cSrcweir<tablerow> 268cdf0e10cSrcweir<tablecell> 26980b082deSmseidel<paragraph role="tablecontent" id="par_id3149909" xml-lang="en-US" l10n="U">Month as January-December</paragraph> 270cdf0e10cSrcweir</tablecell> 271cdf0e10cSrcweir<tablecell> 27280b082deSmseidel<paragraph role="code" id="par_id3155318" xml-lang="en-US" l10n="U">MMMM</paragraph> 273cdf0e10cSrcweir</tablecell> 274cdf0e10cSrcweir</tablerow> 275cdf0e10cSrcweir<tablerow> 276cdf0e10cSrcweir<tablecell> 277*347184d5Smseidel<paragraph role="tablecontent" id="par_id3151218" xml-lang="en-US" l10n="U">First letter of Name of Month</paragraph> 278cdf0e10cSrcweir</tablecell> 279cdf0e10cSrcweir<tablecell> 280*347184d5Smseidel<paragraph role="code" id="par_id3150420" xml-lang="en-US" l10n="U">MMMMM</paragraph> 281cdf0e10cSrcweir</tablecell> 282cdf0e10cSrcweir</tablerow> 283cdf0e10cSrcweir<tablerow> 284cdf0e10cSrcweir<tablecell> 28580b082deSmseidel<paragraph role="tablecontent" id="par_id3154501" xml-lang="en-US" l10n="U">Day as 2</paragraph> 286cdf0e10cSrcweir</tablecell> 287cdf0e10cSrcweir<tablecell> 28880b082deSmseidel<paragraph role="code" id="par_id3156181" xml-lang="en-US" l10n="U">D</paragraph> 289cdf0e10cSrcweir</tablecell> 290cdf0e10cSrcweir</tablerow> 291cdf0e10cSrcweir<tablerow> 292cdf0e10cSrcweir<tablecell> 29380b082deSmseidel<paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US" l10n="U">Day as 02</paragraph> 294cdf0e10cSrcweir</tablecell> 295cdf0e10cSrcweir<tablecell> 29680b082deSmseidel<paragraph role="code" id="par_id3156358" xml-lang="en-US" l10n="U">DD</paragraph> 297cdf0e10cSrcweir</tablecell> 298cdf0e10cSrcweir</tablerow> 299cdf0e10cSrcweir<tablerow> 300cdf0e10cSrcweir<tablecell> 30180b082deSmseidel<paragraph role="tablecontent" id="par_id3148495" xml-lang="en-US" l10n="U">Day as Sun-Sat</paragraph> 302cdf0e10cSrcweir</tablecell> 303cdf0e10cSrcweir<tablecell> 30480b082deSmseidel<paragraph role="code" id="par_id3161665" xml-lang="en-US" l10n="U">NN or DDD</paragraph> 305cdf0e10cSrcweir</tablecell> 306cdf0e10cSrcweir</tablerow> 307cdf0e10cSrcweir<tablerow> 308cdf0e10cSrcweir<tablecell> 309*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154272" xml-lang="en-US" l10n="U">Day as Sunday to Saturday</paragraph> 310cdf0e10cSrcweir</tablecell> 311cdf0e10cSrcweir<tablecell> 312*347184d5Smseidel<paragraph role="code" id="par_id3145164" xml-lang="en-US" l10n="U">NNN or DDDD</paragraph> 313cdf0e10cSrcweir</tablecell> 314cdf0e10cSrcweir</tablerow> 315cdf0e10cSrcweir<tablerow> 316cdf0e10cSrcweir<tablecell> 31780b082deSmseidel<paragraph role="tablecontent" id="par_id3146791" xml-lang="en-US" l10n="U">Day followed by comma, as in "Sunday,"</paragraph> 318cdf0e10cSrcweir</tablecell> 319cdf0e10cSrcweir<tablecell> 32080b082deSmseidel<paragraph role="code" id="par_id3146081" xml-lang="en-US" l10n="U">NNNN</paragraph> 321cdf0e10cSrcweir</tablecell> 322cdf0e10cSrcweir</tablerow> 323cdf0e10cSrcweir<tablerow> 324cdf0e10cSrcweir<tablecell> 32580b082deSmseidel<paragraph role="tablecontent" id="par_id3156275" xml-lang="en-US" l10n="U">Year as 00-99</paragraph> 326cdf0e10cSrcweir</tablecell> 327cdf0e10cSrcweir<tablecell> 32880b082deSmseidel<paragraph role="code" id="par_id3143236" xml-lang="en-US" l10n="U">YY</paragraph> 329cdf0e10cSrcweir</tablecell> 330cdf0e10cSrcweir</tablerow> 331cdf0e10cSrcweir<tablerow> 332cdf0e10cSrcweir<tablecell> 33380b082deSmseidel<paragraph role="tablecontent" id="par_id3148408" xml-lang="en-US" l10n="U">Year as 1900-2078</paragraph> 334cdf0e10cSrcweir</tablecell> 335cdf0e10cSrcweir<tablecell> 33680b082deSmseidel<paragraph role="code" id="par_id3151358" xml-lang="en-US" l10n="U">YYYY</paragraph> 337cdf0e10cSrcweir</tablecell> 338cdf0e10cSrcweir</tablerow> 339cdf0e10cSrcweir<tablerow> 340cdf0e10cSrcweir<tablecell> 34180b082deSmseidel<paragraph role="tablecontent" id="par_id3153355" xml-lang="en-US" l10n="U">Calendar week</paragraph> 342cdf0e10cSrcweir</tablecell> 343cdf0e10cSrcweir<tablecell> 34480b082deSmseidel<paragraph role="code" id="par_id3150744" xml-lang="en-US" l10n="U">WW</paragraph> 345cdf0e10cSrcweir</tablecell> 346cdf0e10cSrcweir</tablerow> 347cdf0e10cSrcweir<tablerow> 348cdf0e10cSrcweir<tablecell> 349*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154302" xml-lang="en-US" l10n="U">Quarterly as Q1 to Q4</paragraph> 350cdf0e10cSrcweir</tablecell> 351cdf0e10cSrcweir<tablecell> 352*347184d5Smseidel<paragraph role="code" id="par_id3159266" xml-lang="en-US" l10n="CHG">Q</paragraph> 353cdf0e10cSrcweir</tablecell> 354cdf0e10cSrcweir</tablerow> 355cdf0e10cSrcweir<tablerow> 356cdf0e10cSrcweir<tablecell> 357*347184d5Smseidel<paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U">Quarterly as 1st quarter to 4th quarter</paragraph> 358cdf0e10cSrcweir</tablecell> 359cdf0e10cSrcweir<tablecell> 360*347184d5Smseidel<paragraph role="code" id="par_id3146918" xml-lang="en-US" l10n="U">QQ</paragraph> 361cdf0e10cSrcweir</tablecell> 362cdf0e10cSrcweir</tablerow> 363cdf0e10cSrcweir<tablerow> 364cdf0e10cSrcweir<tablecell> 365*347184d5Smseidel<paragraph role="tablecontent" id="par_id3147534" xml-lang="en-US" l10n="U">Era on the Japanese Gengou calendar, single character (possible values are: M, T, S, H)</paragraph> 366cdf0e10cSrcweir</tablecell> 367cdf0e10cSrcweir<tablecell> 368*347184d5Smseidel<paragraph role="code" id="par_id3151249" xml-lang="en-US" l10n="U">G</paragraph> 369cdf0e10cSrcweir</tablecell> 370cdf0e10cSrcweir</tablerow> 371cdf0e10cSrcweir<tablerow> 372cdf0e10cSrcweir<tablecell> 373*347184d5Smseidel<paragraph role="tablecontent" id="par_id3163806" xml-lang="en-US" l10n="U">Era, abbreviation</paragraph> 374cdf0e10cSrcweir</tablecell> 375cdf0e10cSrcweir<tablecell> 376*347184d5Smseidel<paragraph role="code" id="par_id3155962" xml-lang="en-US" l10n="U">GG</paragraph> 377cdf0e10cSrcweir</tablecell> 378cdf0e10cSrcweir</tablerow> 379cdf0e10cSrcweir<tablerow> 380cdf0e10cSrcweir<tablecell> 381*347184d5Smseidel<paragraph role="tablecontent" id="par_id3151187" xml-lang="en-US" l10n="U">Era, full name</paragraph> 382cdf0e10cSrcweir</tablecell> 383cdf0e10cSrcweir<tablecell> 384*347184d5Smseidel<paragraph role="code" id="par_id3149568" xml-lang="en-US" l10n="U">GGG</paragraph> 385cdf0e10cSrcweir</tablecell> 386cdf0e10cSrcweir</tablerow> 387cdf0e10cSrcweir<tablerow> 388cdf0e10cSrcweir<tablecell> 389*347184d5Smseidel<paragraph role="tablecontent" id="par_id3147344" xml-lang="en-US" l10n="U">Number of the year within an era, without a leading zero for single-digit years</paragraph> 390cdf0e10cSrcweir</tablecell> 391cdf0e10cSrcweir<tablecell> 392*347184d5Smseidel<paragraph role="code" id="par_id3147255" xml-lang="en-US" l10n="U">E</paragraph> 393cdf0e10cSrcweir</tablecell> 394cdf0e10cSrcweir</tablerow> 395cdf0e10cSrcweir<tablerow> 396cdf0e10cSrcweir<tablecell> 397*347184d5Smseidel<paragraph role="tablecontent" id="par_id3148487" xml-lang="en-US" l10n="U">Number of the year within an era, with a leading zero for single-digit years</paragraph> 398cdf0e10cSrcweir</tablecell> 399cdf0e10cSrcweir<tablecell> 400*347184d5Smseidel<paragraph role="code" id="par_id3150298" xml-lang="en-US" l10n="U">EE or R</paragraph> 401cdf0e10cSrcweir</tablecell> 402cdf0e10cSrcweir</tablerow> 403cdf0e10cSrcweir<tablerow> 404cdf0e10cSrcweir<tablecell> 405*347184d5Smseidel<paragraph role="tablecontent" id="par_id3152861" xml-lang="en-US" l10n="U">Era, full name and year</paragraph> 406cdf0e10cSrcweir</tablecell> 407cdf0e10cSrcweir<tablecell> 408*347184d5Smseidel<paragraph role="code" id="par_id3149926" xml-lang="en-US" l10n="U">RR or GGGEE</paragraph> 409cdf0e10cSrcweir</tablecell> 410cdf0e10cSrcweir</tablerow> 411cdf0e10cSrcweir</table> 412cdf0e10cSrcweir<paragraph role="paragraph" id="par_id1002200811423518" xml-lang="en-US" l10n="NEW">The above listed formatting codes work with your language version of %PRODUCTNAME. However, when you need to switch the locale of %PRODUCTNAME to another locale, you will need to know the formatting codes used in that other locale.</paragraph> 413cdf0e10cSrcweir<paragraph role="paragraph" id="par_id1002200811423556" xml-lang="en-US" l10n="NEW">For example, if your software is set to an English locale, and you want to format a year with four digits, you enter YYYY as a formatting code. When you switch to a German locale, you must use JJJJ instead. The following table lists only the localized differences.</paragraph> 414cdf0e10cSrcweir<table id="tbl_id1002200811465915"> 415cdf0e10cSrcweir<tablerow> 416cdf0e10cSrcweir<tablecell> 417cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563044" xml-lang="en-US" l10n="NEW">Locale</paragraph> 418cdf0e10cSrcweir</tablecell> 419cdf0e10cSrcweir<tablecell> 420cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563137" xml-lang="en-US" l10n="NEW">Year</paragraph> 421cdf0e10cSrcweir</tablecell> 422cdf0e10cSrcweir<tablecell> 423cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563164" xml-lang="en-US" l10n="NEW">Month</paragraph> 424cdf0e10cSrcweir</tablecell> 425cdf0e10cSrcweir<tablecell> 426cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563128" xml-lang="en-US" l10n="NEW">Day</paragraph> 427cdf0e10cSrcweir</tablecell> 428cdf0e10cSrcweir<tablecell> 429cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563135" xml-lang="en-US" l10n="NEW">Hour</paragraph> 430cdf0e10cSrcweir</tablecell> 431cdf0e10cSrcweir<tablecell> 432cdf0e10cSrcweir<paragraph role="tablehead" id="par_id1002200811563289" xml-lang="en-US" l10n="NEW">Day Of Week</paragraph> 433cdf0e10cSrcweir</tablecell> 434cdf0e10cSrcweir<tablecell> 435cdf0e10cSrcweir<paragraph role="tablehead" id="par_id100220081156322" xml-lang="en-US" l10n="NEW">Era</paragraph> 436cdf0e10cSrcweir</tablecell> 437cdf0e10cSrcweir</tablerow> 438cdf0e10cSrcweir<tablerow> 439cdf0e10cSrcweir<tablecell> 440cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563233" xml-lang="en-US" l10n="NEW">English - en</paragraph> 441cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563243" xml-lang="en-US" l10n="NEW">and all not listed locales</paragraph> 442cdf0e10cSrcweir</tablecell> 443cdf0e10cSrcweir<tablecell> 444cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563352" xml-lang="en-US" l10n="NEW">Y</paragraph> 445cdf0e10cSrcweir</tablecell> 446cdf0e10cSrcweir<tablecell> 447cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563396" xml-lang="en-US" l10n="NEW">M</paragraph> 448cdf0e10cSrcweir</tablecell> 449cdf0e10cSrcweir<tablecell> 450cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563385" xml-lang="en-US" l10n="NEW">D</paragraph> 451cdf0e10cSrcweir</tablecell> 452cdf0e10cSrcweir<tablecell> 453cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563472" xml-lang="en-US" l10n="NEW">H</paragraph> 454cdf0e10cSrcweir</tablecell> 455cdf0e10cSrcweir<tablecell> 456cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563430" xml-lang="en-US" l10n="NEW">A</paragraph> 457cdf0e10cSrcweir</tablecell> 458cdf0e10cSrcweir<tablecell> 459cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563488" xml-lang="en-US" l10n="NEW">G</paragraph> 460cdf0e10cSrcweir</tablecell> 461cdf0e10cSrcweir</tablerow> 462cdf0e10cSrcweir<tablerow> 463cdf0e10cSrcweir<tablecell> 464cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563484" xml-lang="en-US" l10n="NEW">German - de</paragraph> 465cdf0e10cSrcweir</tablecell> 466cdf0e10cSrcweir<tablecell> 467cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563518" xml-lang="en-US" l10n="NEW">J</paragraph> 468cdf0e10cSrcweir</tablecell> 469cdf0e10cSrcweir<tablecell> 470cdf0e10cSrcweir</tablecell> 471cdf0e10cSrcweir<tablecell> 472cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563735" xml-lang="en-US" l10n="NEW">T</paragraph> 473cdf0e10cSrcweir</tablecell> 474cdf0e10cSrcweir<tablecell> 475cdf0e10cSrcweir</tablecell> 476cdf0e10cSrcweir<tablecell> 477cdf0e10cSrcweir</tablecell> 478cdf0e10cSrcweir<tablecell> 479cdf0e10cSrcweir</tablecell> 480cdf0e10cSrcweir</tablerow> 481cdf0e10cSrcweir<tablerow> 482cdf0e10cSrcweir<tablecell> 483cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563823" xml-lang="en-US" l10n="NEW">Netherlands - nl</paragraph> 484cdf0e10cSrcweir</tablecell> 485cdf0e10cSrcweir<tablecell> 486cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563852" xml-lang="en-US" l10n="NEW">J</paragraph> 487cdf0e10cSrcweir</tablecell> 488cdf0e10cSrcweir<tablecell> 489cdf0e10cSrcweir</tablecell> 490cdf0e10cSrcweir<tablecell> 491cdf0e10cSrcweir</tablecell> 492cdf0e10cSrcweir<tablecell> 493cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563827" xml-lang="en-US" l10n="NEW">U</paragraph> 494cdf0e10cSrcweir</tablecell> 495cdf0e10cSrcweir<tablecell> 496cdf0e10cSrcweir</tablecell> 497cdf0e10cSrcweir<tablecell> 498cdf0e10cSrcweir</tablecell> 499cdf0e10cSrcweir</tablerow> 500cdf0e10cSrcweir<tablerow> 501cdf0e10cSrcweir<tablecell> 502cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563916" xml-lang="en-US" l10n="NEW">French - fr</paragraph> 503cdf0e10cSrcweir</tablecell> 504cdf0e10cSrcweir<tablecell> 505cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563970" xml-lang="en-US" l10n="NEW">A</paragraph> 506cdf0e10cSrcweir</tablecell> 507cdf0e10cSrcweir<tablecell> 508cdf0e10cSrcweir</tablecell> 509cdf0e10cSrcweir<tablecell> 510cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811563980" xml-lang="en-US" l10n="NEW">J</paragraph> 511cdf0e10cSrcweir</tablecell> 512cdf0e10cSrcweir<tablecell> 513cdf0e10cSrcweir</tablecell> 514cdf0e10cSrcweir<tablecell> 515cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564065" xml-lang="en-US" l10n="NEW">O</paragraph> 516cdf0e10cSrcweir</tablecell> 517cdf0e10cSrcweir<tablecell> 518cdf0e10cSrcweir</tablecell> 519cdf0e10cSrcweir</tablerow> 520cdf0e10cSrcweir<tablerow> 521cdf0e10cSrcweir<tablecell> 522cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156407" xml-lang="en-US" l10n="NEW">Italian - it</paragraph> 523cdf0e10cSrcweir</tablecell> 524cdf0e10cSrcweir<tablecell> 525cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156403" xml-lang="en-US" l10n="NEW">A</paragraph> 526cdf0e10cSrcweir</tablecell> 527cdf0e10cSrcweir<tablecell> 528cdf0e10cSrcweir</tablecell> 529cdf0e10cSrcweir<tablecell> 530cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564042" xml-lang="en-US" l10n="NEW">G</paragraph> 531cdf0e10cSrcweir</tablecell> 532cdf0e10cSrcweir<tablecell> 533cdf0e10cSrcweir</tablecell> 534cdf0e10cSrcweir<tablecell> 535cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156412" xml-lang="en-US" l10n="NEW">O</paragraph> 536cdf0e10cSrcweir</tablecell> 537cdf0e10cSrcweir<tablecell> 538cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564119" xml-lang="en-US" l10n="NEW">X</paragraph> 539cdf0e10cSrcweir</tablecell> 540cdf0e10cSrcweir</tablerow> 541cdf0e10cSrcweir<tablerow> 542cdf0e10cSrcweir<tablecell> 543cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564197" xml-lang="en-US" l10n="NEW">Portuguese - pt</paragraph> 544cdf0e10cSrcweir</tablecell> 545cdf0e10cSrcweir<tablecell> 546cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564272" xml-lang="en-US" l10n="NEW">A</paragraph> 547cdf0e10cSrcweir</tablecell> 548cdf0e10cSrcweir<tablecell> 549cdf0e10cSrcweir</tablecell> 550cdf0e10cSrcweir<tablecell> 551cdf0e10cSrcweir</tablecell> 552cdf0e10cSrcweir<tablecell> 553cdf0e10cSrcweir</tablecell> 554cdf0e10cSrcweir<tablecell> 555cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156423" xml-lang="en-US" l10n="NEW">O</paragraph> 556cdf0e10cSrcweir</tablecell> 557cdf0e10cSrcweir<tablecell> 558cdf0e10cSrcweir</tablecell> 559cdf0e10cSrcweir</tablerow> 560cdf0e10cSrcweir<tablerow> 561cdf0e10cSrcweir<tablecell> 562cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564218" xml-lang="en-US" l10n="NEW">Spanish - es</paragraph> 563cdf0e10cSrcweir</tablecell> 564cdf0e10cSrcweir<tablecell> 565cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564390" xml-lang="en-US" l10n="NEW">A</paragraph> 566cdf0e10cSrcweir</tablecell> 567cdf0e10cSrcweir<tablecell> 568cdf0e10cSrcweir</tablecell> 569cdf0e10cSrcweir<tablecell> 570cdf0e10cSrcweir</tablecell> 571cdf0e10cSrcweir<tablecell> 572cdf0e10cSrcweir</tablecell> 573cdf0e10cSrcweir<tablecell> 574cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564319" xml-lang="en-US" l10n="NEW">O</paragraph> 575cdf0e10cSrcweir</tablecell> 576cdf0e10cSrcweir<tablecell> 577cdf0e10cSrcweir</tablecell> 578cdf0e10cSrcweir</tablerow> 579cdf0e10cSrcweir<tablerow> 580cdf0e10cSrcweir<tablecell> 581cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156433" xml-lang="en-US" l10n="NEW">Danish - da</paragraph> 582cdf0e10cSrcweir</tablecell> 583cdf0e10cSrcweir<tablecell> 584cdf0e10cSrcweir</tablecell> 585cdf0e10cSrcweir<tablecell> 586cdf0e10cSrcweir</tablecell> 587cdf0e10cSrcweir<tablecell> 588cdf0e10cSrcweir</tablecell> 589cdf0e10cSrcweir<tablecell> 590cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id100220081156444" xml-lang="en-US" l10n="NEW">T</paragraph> 591cdf0e10cSrcweir</tablecell> 592cdf0e10cSrcweir<tablecell> 593cdf0e10cSrcweir</tablecell> 594cdf0e10cSrcweir<tablecell> 595cdf0e10cSrcweir</tablecell> 596cdf0e10cSrcweir</tablerow> 597cdf0e10cSrcweir<tablerow> 598cdf0e10cSrcweir<tablecell> 599cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564448" xml-lang="en-US" l10n="NEW">Norwegian - no, nb, nn</paragraph> 600cdf0e10cSrcweir</tablecell> 601cdf0e10cSrcweir<tablecell> 602cdf0e10cSrcweir</tablecell> 603cdf0e10cSrcweir<tablecell> 604cdf0e10cSrcweir</tablecell> 605cdf0e10cSrcweir<tablecell> 606cdf0e10cSrcweir</tablecell> 607cdf0e10cSrcweir<tablecell> 608cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564549" xml-lang="en-US" l10n="NEW">T</paragraph> 609cdf0e10cSrcweir</tablecell> 610cdf0e10cSrcweir<tablecell> 611cdf0e10cSrcweir</tablecell> 612cdf0e10cSrcweir<tablecell> 613cdf0e10cSrcweir</tablecell> 614cdf0e10cSrcweir</tablerow> 615cdf0e10cSrcweir<tablerow> 616cdf0e10cSrcweir<tablecell> 617cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564565" xml-lang="en-US" l10n="NEW">Swedish - sv</paragraph> 618cdf0e10cSrcweir</tablecell> 619cdf0e10cSrcweir<tablecell> 620cdf0e10cSrcweir</tablecell> 621cdf0e10cSrcweir<tablecell> 622cdf0e10cSrcweir</tablecell> 623cdf0e10cSrcweir<tablecell> 624cdf0e10cSrcweir</tablecell> 625cdf0e10cSrcweir<tablecell> 626cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564556" xml-lang="en-US" l10n="NEW">T</paragraph> 627cdf0e10cSrcweir</tablecell> 628cdf0e10cSrcweir<tablecell> 629cdf0e10cSrcweir</tablecell> 630cdf0e10cSrcweir<tablecell> 631cdf0e10cSrcweir</tablecell> 632cdf0e10cSrcweir</tablerow> 633cdf0e10cSrcweir<tablerow> 634cdf0e10cSrcweir<tablecell> 635cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564637" xml-lang="en-US" l10n="NEW">Finnish - fi</paragraph> 636cdf0e10cSrcweir</tablecell> 637cdf0e10cSrcweir<tablecell> 638cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564627" xml-lang="en-US" l10n="NEW">V</paragraph> 639cdf0e10cSrcweir</tablecell> 640cdf0e10cSrcweir<tablecell> 641cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564643" xml-lang="en-US" l10n="NEW">K</paragraph> 642cdf0e10cSrcweir</tablecell> 643cdf0e10cSrcweir<tablecell> 644cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564763" xml-lang="en-US" l10n="NEW">P</paragraph> 645cdf0e10cSrcweir</tablecell> 646cdf0e10cSrcweir<tablecell> 647cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id1002200811564715" xml-lang="en-US" l10n="NEW">T</paragraph> 648cdf0e10cSrcweir</tablecell> 649cdf0e10cSrcweir<tablecell> 650cdf0e10cSrcweir</tablecell> 651cdf0e10cSrcweir<tablecell> 652cdf0e10cSrcweir</tablecell> 653cdf0e10cSrcweir</tablerow> 654cdf0e10cSrcweir</table> 655*347184d5Smseidel<paragraph role="heading" id="hd_id3149929" xml-lang="en-US" level="3" l10n="U">Entering Dates</paragraph> 656*347184d5Smseidel<paragraph role="paragraph" id="par_id3148397" xml-lang="en-US" l10n="U">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> 657*347184d5Smseidel<paragraph role="paragraph" id="par_id3153274" xml-lang="en-US" l10n="U">All date formats are dependent on the locale that is set in <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - 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> 658*347184d5Smseidel<paragraph role="paragraph" id="par_id3153795" xml-lang="en-US" l10n="U">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> 659cdf0e10cSrcweir<table id="tbl_id3145133"> 660cdf0e10cSrcweir<tablerow> 661cdf0e10cSrcweir<tablecell> 662*347184d5Smseidel<paragraph role="tablehead" id="par_id3145764" xml-lang="en-US" l10n="U">Modifier</paragraph> 663cdf0e10cSrcweir</tablecell> 664cdf0e10cSrcweir<tablecell> 665*347184d5Smseidel<paragraph role="tablehead" id="par_id3152967" xml-lang="en-US" l10n="U">Calendar</paragraph> 666cdf0e10cSrcweir</tablecell> 667cdf0e10cSrcweir</tablerow> 668cdf0e10cSrcweir<tablerow> 669cdf0e10cSrcweir<tablecell> 670*347184d5Smseidel<paragraph role="code" id="par_id3148390" xml-lang="en-US" l10n="U">[~buddhist]</paragraph> 671cdf0e10cSrcweir</tablecell> 672cdf0e10cSrcweir<tablecell> 673*347184d5Smseidel<paragraph role="tablecontent" id="par_id3153781" xml-lang="en-US" l10n="U">Thai Buddhist Calendar</paragraph> 674cdf0e10cSrcweir</tablecell> 675cdf0e10cSrcweir</tablerow> 676cdf0e10cSrcweir<tablerow> 677cdf0e10cSrcweir<tablecell> 678*347184d5Smseidel<paragraph role="code" id="par_id3157969" xml-lang="en-US" l10n="U">[~gengou]</paragraph> 679cdf0e10cSrcweir</tablecell> 680cdf0e10cSrcweir<tablecell> 681*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154656" xml-lang="en-US" l10n="U">Japanese Gengou Calendar</paragraph> 682cdf0e10cSrcweir</tablecell> 683cdf0e10cSrcweir</tablerow> 684cdf0e10cSrcweir<tablerow> 685cdf0e10cSrcweir<tablecell> 686*347184d5Smseidel<paragraph role="code" id="par_id3150086" xml-lang="en-US" l10n="U">[~gregorian]</paragraph> 687cdf0e10cSrcweir</tablecell> 688cdf0e10cSrcweir<tablecell> 689*347184d5Smseidel<paragraph role="tablecontent" id="par_id3146070" xml-lang="en-US" l10n="U">Gregorian Calendar</paragraph> 690cdf0e10cSrcweir</tablecell> 691cdf0e10cSrcweir</tablerow> 692cdf0e10cSrcweir<tablerow> 693cdf0e10cSrcweir<tablecell> 694*347184d5Smseidel<paragraph role="code" id="par_id3146808" xml-lang="en-US" l10n="U">[~hanja] or [~hanja_yoil]</paragraph> 695cdf0e10cSrcweir</tablecell> 696cdf0e10cSrcweir<tablecell> 697*347184d5Smseidel<paragraph role="tablecontent" id="par_id3149207" xml-lang="en-US" l10n="U">Korean Calendar</paragraph> 698cdf0e10cSrcweir</tablecell> 699cdf0e10cSrcweir</tablerow> 700cdf0e10cSrcweir<tablerow> 701cdf0e10cSrcweir<tablecell> 702*347184d5Smseidel<paragraph role="code" id="par_id3150304" xml-lang="en-US" l10n="U">[~hijri]</paragraph> 703cdf0e10cSrcweir</tablecell> 704cdf0e10cSrcweir<tablecell> 705*347184d5Smseidel<paragraph role="tablecontent" id="par_id3149238" xml-lang="en-US" l10n="U">Arabic Islamic Calendar, currently supported for the following locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph> 706cdf0e10cSrcweir</tablecell> 707cdf0e10cSrcweir</tablerow> 708cdf0e10cSrcweir<tablerow> 709cdf0e10cSrcweir<tablecell> 710*347184d5Smseidel<paragraph role="code" id="par_id3154903" xml-lang="en-US" l10n="U">[~jewish]</paragraph> 711cdf0e10cSrcweir</tablecell> 712cdf0e10cSrcweir<tablecell> 713*347184d5Smseidel<paragraph role="tablecontent" id="par_id3151288" xml-lang="en-US" l10n="U">Jewish Calendar</paragraph> 714cdf0e10cSrcweir</tablecell> 715cdf0e10cSrcweir</tablerow> 716cdf0e10cSrcweir<tablerow> 717cdf0e10cSrcweir<tablecell> 718*347184d5Smseidel<paragraph role="code" id="par_id3166442" xml-lang="en-US" l10n="U">[~ROC]</paragraph> 719cdf0e10cSrcweir</tablecell> 720cdf0e10cSrcweir<tablecell> 721*347184d5Smseidel<paragraph role="tablecontent" id="par_id3145587" xml-lang="en-US" l10n="U">Republic Of China Calendar</paragraph> 722cdf0e10cSrcweir</tablecell> 723cdf0e10cSrcweir</tablerow> 724cdf0e10cSrcweir</table> 725*347184d5Smseidel<paragraph role="paragraph" id="par_id3152419" xml-lang="en-US" l10n="U"><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> 726cdf0e10cSrcweir<switch select="appl"> 727cdf0e10cSrcweir<case select="CALC"> 728cdf0e10cSrcweir<table id="tbl_id3150490"> 729cdf0e10cSrcweir<tablerow> 730cdf0e10cSrcweir<tablecell> 731*347184d5Smseidel<paragraph role="tablehead" id="par_id3154194" xml-lang="en-US" l10n="U">Initial Format</paragraph> 732cdf0e10cSrcweir</tablecell> 733cdf0e10cSrcweir<tablecell> 734*347184d5Smseidel<paragraph role="tablehead" id="par_id3149787" xml-lang="en-US" l10n="U">Result Format</paragraph> 735cdf0e10cSrcweir</tablecell> 736cdf0e10cSrcweir</tablerow> 737cdf0e10cSrcweir<tablerow> 738cdf0e10cSrcweir<tablecell> 739*347184d5Smseidel<paragraph role="tablecontent" id="par_id3152993" xml-lang="en-US" l10n="U">Date + Date</paragraph> 740cdf0e10cSrcweir</tablecell> 741cdf0e10cSrcweir<tablecell> 742*347184d5Smseidel<paragraph role="tablecontent" id="par_id3150292" xml-lang="en-US" l10n="U">Number (Days)</paragraph> 743cdf0e10cSrcweir</tablecell> 744cdf0e10cSrcweir</tablerow> 745cdf0e10cSrcweir<tablerow> 746cdf0e10cSrcweir<tablecell> 747*347184d5Smseidel<paragraph role="tablecontent" id="par_id3150460" xml-lang="en-US" l10n="U">Date + Number</paragraph> 748cdf0e10cSrcweir</tablecell> 749cdf0e10cSrcweir<tablecell> 750*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154371" xml-lang="en-US" l10n="U">Date</paragraph> 751cdf0e10cSrcweir</tablecell> 752cdf0e10cSrcweir</tablerow> 753cdf0e10cSrcweir<tablerow> 754cdf0e10cSrcweir<tablecell> 755*347184d5Smseidel<paragraph role="tablecontent" id="par_id3145082" xml-lang="en-US" l10n="U">Date + Time</paragraph> 756cdf0e10cSrcweir</tablecell> 757cdf0e10cSrcweir<tablecell> 758*347184d5Smseidel<paragraph role="tablecontent" id="par_id3156290" xml-lang="en-US" l10n="U">Date&Time</paragraph> 759cdf0e10cSrcweir</tablecell> 760cdf0e10cSrcweir</tablerow> 761cdf0e10cSrcweir<tablerow> 762cdf0e10cSrcweir<tablecell> 763*347184d5Smseidel<paragraph role="tablecontent" id="par_id3152456" xml-lang="en-US" l10n="U">Date + Date&Time</paragraph> 764cdf0e10cSrcweir</tablecell> 765cdf0e10cSrcweir<tablecell> 766*347184d5Smseidel<paragraph role="tablecontent" id="par_id3156169" xml-lang="en-US" l10n="U">Number</paragraph> 767cdf0e10cSrcweir</tablecell> 768cdf0e10cSrcweir</tablerow> 769cdf0e10cSrcweir<tablerow> 770cdf0e10cSrcweir<tablecell> 771*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154527" xml-lang="en-US" l10n="U">Time + Time</paragraph> 772cdf0e10cSrcweir</tablecell> 773cdf0e10cSrcweir<tablecell> 774*347184d5Smseidel<paragraph role="tablecontent" id="par_id3159625" xml-lang="en-US" l10n="U">Time</paragraph> 775cdf0e10cSrcweir</tablecell> 776cdf0e10cSrcweir</tablerow> 777cdf0e10cSrcweir<tablerow> 778cdf0e10cSrcweir<tablecell> 779*347184d5Smseidel<paragraph role="tablecontent" id="par_id3146802" xml-lang="en-US" l10n="U">Time + Number</paragraph> 780cdf0e10cSrcweir</tablecell> 781cdf0e10cSrcweir<tablecell> 782*347184d5Smseidel<paragraph role="tablecontent" id="par_id3146770" xml-lang="en-US" l10n="U">Time</paragraph> 783cdf0e10cSrcweir</tablecell> 784cdf0e10cSrcweir</tablerow> 785cdf0e10cSrcweir<tablerow> 786cdf0e10cSrcweir<tablecell> 787*347184d5Smseidel<paragraph role="tablecontent" id="par_id3155500" xml-lang="en-US" l10n="U">Time + Date&Time</paragraph> 788cdf0e10cSrcweir</tablecell> 789cdf0e10cSrcweir<tablecell> 790*347184d5Smseidel<paragraph role="tablecontent" id="par_id3155128" xml-lang="en-US" l10n="U">Date&Time</paragraph> 791cdf0e10cSrcweir</tablecell> 792cdf0e10cSrcweir</tablerow> 793cdf0e10cSrcweir<tablerow> 794cdf0e10cSrcweir<tablecell> 795*347184d5Smseidel<paragraph role="tablecontent" id="par_id3152904" xml-lang="en-US" l10n="U">Date&Time + Date&Time</paragraph> 796cdf0e10cSrcweir</tablecell> 797cdf0e10cSrcweir<tablecell> 798*347184d5Smseidel<paragraph role="tablecontent" id="par_id3159143" xml-lang="en-US" l10n="U">Time</paragraph> 799cdf0e10cSrcweir</tablecell> 800cdf0e10cSrcweir</tablerow> 801cdf0e10cSrcweir<tablerow> 802cdf0e10cSrcweir<tablecell> 803*347184d5Smseidel<paragraph role="tablecontent" id="par_id3148909" xml-lang="en-US" l10n="U">Date&Time + Number</paragraph> 804cdf0e10cSrcweir</tablecell> 805cdf0e10cSrcweir<tablecell> 806*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154806" xml-lang="en-US" l10n="U">Date&Time</paragraph> 807cdf0e10cSrcweir</tablecell> 808cdf0e10cSrcweir</tablerow> 809cdf0e10cSrcweir<tablerow> 810cdf0e10cSrcweir<tablecell> 811*347184d5Smseidel<paragraph role="tablecontent" id="par_id3151269" xml-lang="en-US" l10n="U">Number + Number</paragraph> 812cdf0e10cSrcweir</tablecell> 813cdf0e10cSrcweir<tablecell> 814*347184d5Smseidel<paragraph role="tablecontent" id="par_id3154951" xml-lang="en-US" l10n="U">Number</paragraph> 815cdf0e10cSrcweir</tablecell> 816cdf0e10cSrcweir</tablerow> 817cdf0e10cSrcweir</table> 818cdf0e10cSrcweir</case> 819cdf0e10cSrcweir</switch> 820*347184d5Smseidel<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US" l10n="U"><switchinline select="appl"><caseinline select="CALC">The Date&Time format displays the date and time that an entry was made to a cell with this format.</caseinline></switchinline></paragraph> 821cdf0e10cSrcweir<switch select="appl"> 822cdf0e10cSrcweir<case select="CALC"><embed href="text/shared/optionen/01010600.xhp#jahreszahlen"/> 823*347184d5Smseidel<paragraph role="note" id="par_id3143225" xml-lang="en-US" l10n="U">In <item type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds to Dec 30, 1899.</paragraph> 824cdf0e10cSrcweir</case> 825cdf0e10cSrcweir</switch> 82680b082deSmseidel<paragraph role="heading" id="hd_id3155870" xml-lang="en-US" level="3" l10n="U">Time Formats</paragraph> 82780b082deSmseidel<paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U">To display hours, minutes and seconds use the following number format codes.</paragraph> 828cdf0e10cSrcweir<table id="tbl_id3154830"> 829cdf0e10cSrcweir<tablerow> 830cdf0e10cSrcweir<tablecell> 83180b082deSmseidel<paragraph role="tablehead" id="par_id3149158" xml-lang="en-US" l10n="U">Format</paragraph> 832cdf0e10cSrcweir</tablecell> 833cdf0e10cSrcweir<tablecell> 83480b082deSmseidel<paragraph role="tablehead" id="par_id3154341" xml-lang="en-US" l10n="U">Format Code</paragraph> 835cdf0e10cSrcweir</tablecell> 836cdf0e10cSrcweir</tablerow> 837cdf0e10cSrcweir<tablerow> 838cdf0e10cSrcweir<tablecell> 83980b082deSmseidel<paragraph role="tablecontent" id="par_id3154557" xml-lang="en-US" l10n="U">Hours as 0-23</paragraph> 840cdf0e10cSrcweir</tablecell> 841cdf0e10cSrcweir<tablecell> 84280b082deSmseidel<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U">h</paragraph> 843cdf0e10cSrcweir</tablecell> 844cdf0e10cSrcweir</tablerow> 845cdf0e10cSrcweir<tablerow> 846cdf0e10cSrcweir<tablecell> 84780b082deSmseidel<paragraph role="tablecontent" id="par_id3143218" xml-lang="en-US" l10n="U">Hours as 00-23</paragraph> 848cdf0e10cSrcweir</tablecell> 849cdf0e10cSrcweir<tablecell> 85080b082deSmseidel<paragraph role="code" id="par_id3155266" xml-lang="en-US" l10n="U">hh</paragraph> 851cdf0e10cSrcweir</tablecell> 852cdf0e10cSrcweir</tablerow> 853cdf0e10cSrcweir<tablerow> 854cdf0e10cSrcweir<tablecell> 85580b082deSmseidel<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U">Minutes as 0-59</paragraph> 856cdf0e10cSrcweir</tablecell> 857cdf0e10cSrcweir<tablecell> 85880b082deSmseidel<paragraph role="code" id="par_id3149588" xml-lang="en-US" l10n="U">m</paragraph> 859cdf0e10cSrcweir</tablecell> 860cdf0e10cSrcweir</tablerow> 861cdf0e10cSrcweir<tablerow> 862cdf0e10cSrcweir<tablecell> 86380b082deSmseidel<paragraph role="tablecontent" id="par_id3150531" xml-lang="en-US" l10n="U">Minutes as 00-59</paragraph> 864cdf0e10cSrcweir</tablecell> 865cdf0e10cSrcweir<tablecell> 86680b082deSmseidel<paragraph role="code" id="par_id3147409" xml-lang="en-US" l10n="U">mm</paragraph> 867cdf0e10cSrcweir</tablecell> 868cdf0e10cSrcweir</tablerow> 869cdf0e10cSrcweir<tablerow> 870cdf0e10cSrcweir<tablecell> 87180b082deSmseidel<paragraph role="tablecontent" id="par_id3154854" xml-lang="en-US" l10n="U">Seconds as 0-59</paragraph> 872cdf0e10cSrcweir</tablecell> 873cdf0e10cSrcweir<tablecell> 87480b082deSmseidel<paragraph role="code" id="par_id3156173" xml-lang="en-US" l10n="U">s</paragraph> 875cdf0e10cSrcweir</tablecell> 876cdf0e10cSrcweir</tablerow> 877cdf0e10cSrcweir<tablerow> 878cdf0e10cSrcweir<tablecell> 87980b082deSmseidel<paragraph role="tablecontent" id="par_id3149506" xml-lang="en-US" l10n="U">Seconds as 00-59</paragraph> 880cdf0e10cSrcweir</tablecell> 881cdf0e10cSrcweir<tablecell> 88280b082deSmseidel<paragraph role="code" id="par_id3157981" xml-lang="en-US" l10n="U">ss</paragraph> 883cdf0e10cSrcweir</tablecell> 884cdf0e10cSrcweir</tablerow> 885cdf0e10cSrcweir</table> 88680b082deSmseidel<paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U">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> 887*347184d5Smseidel<paragraph role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U">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> 888*347184d5Smseidel<paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U">Displaying Numbers Using Native Characters</paragraph> 889*347184d5Smseidel<paragraph role="paragraph" id="par_id3149998" xml-lang="en-US" l10n="U">To display numbers using native number characters, use a [NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number format codes.</paragraph> 890*347184d5Smseidel<paragraph role="paragraph" id="par_id3154600" xml-lang="en-US" l10n="U">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> 891*347184d5Smseidel<paragraph role="example" id="par_id3152546" xml-lang="en-US" l10n="U">[NatNum1][$-411]0</paragraph> 892*347184d5Smseidel<paragraph role="paragraph" id="par_id3147269" xml-lang="en-US" l10n="U">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> 893cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN11234" xml-lang="en-US" l10n="NEW">Displaying dates using [NatNum] modifiers can have a different effect than displaying other types of numbers. Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier, while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date formats for that particular modifier are not supported.</paragraph> 894*347184d5Smseidel<paragraph role="heading" id="par_id3153111" xml-lang="en-US" level="3" l10n="CHG">[NatNum1] Transliterations</paragraph> 895cdf0e10cSrcweir<table id="tbl_id1136841"> 896cdf0e10cSrcweir<tablerow> 897cdf0e10cSrcweir<tablecell> 898*347184d5Smseidel<paragraph role="paragraph" id="par_id3146895" xml-lang="en-US" l10n="U">Chinese: Chinese lower case characters; CAL: 1/7/7 [DBNum1]</paragraph> 899cdf0e10cSrcweir</tablecell> 900cdf0e10cSrcweir</tablerow> 901cdf0e10cSrcweir<tablerow> 902cdf0e10cSrcweir<tablecell> 903*347184d5Smseidel<paragraph role="paragraph" id="par_id3152536" xml-lang="en-US" l10n="U">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4 [DBNum1]</paragraph> 904cdf0e10cSrcweir</tablecell> 905cdf0e10cSrcweir</tablerow> 906cdf0e10cSrcweir<tablerow> 907cdf0e10cSrcweir<tablecell> 908*347184d5Smseidel<paragraph role="paragraph" id="par_id3146125" xml-lang="en-US" l10n="U">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7 [DBNum1]</paragraph> 909cdf0e10cSrcweir</tablecell> 910cdf0e10cSrcweir</tablerow> 911cdf0e10cSrcweir<tablerow> 912cdf0e10cSrcweir<tablecell> 913*347184d5Smseidel<paragraph role="paragraph" id="par_id3149945" xml-lang="en-US" l10n="U">Thai: Thai characters</paragraph> 914cdf0e10cSrcweir</tablecell> 915cdf0e10cSrcweir</tablerow> 916cdf0e10cSrcweir<tablerow> 917cdf0e10cSrcweir<tablecell> 918*347184d5Smseidel<paragraph role="paragraph" id="par_id3153264" xml-lang="en-US" l10n="U">Arabic: Indic characters</paragraph> 919cdf0e10cSrcweir</tablecell> 920cdf0e10cSrcweir</tablerow> 921cdf0e10cSrcweir<tablerow> 922cdf0e10cSrcweir<tablecell> 923*347184d5Smseidel<paragraph role="paragraph" id="par_id3148973" xml-lang="en-US" l10n="U">Indic: Indic characters</paragraph> 924cdf0e10cSrcweir</tablecell> 925cdf0e10cSrcweir</tablerow> 926cdf0e10cSrcweir<tablerow> 927cdf0e10cSrcweir<tablecell> 928cdf0e10cSrcweir<paragraph role="paragraph" id="par_idN112A3" xml-lang="en-US" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph> 929cdf0e10cSrcweir</tablecell> 930cdf0e10cSrcweir</tablerow> 931cdf0e10cSrcweir<tablerow> 932cdf0e10cSrcweir<tablecell> 933*347184d5Smseidel<paragraph role="paragraph" id="par_id3147520" xml-lang="en-US" l10n="U">[NatNum2] Transliteration in</paragraph> 934cdf0e10cSrcweir</tablecell> 935cdf0e10cSrcweir</tablerow> 936cdf0e10cSrcweir<tablerow> 937cdf0e10cSrcweir<tablecell> 938*347184d5Smseidel<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U">Chinese: Chinese upper case characters; CAL: 2/8/8 [DBNum2]</paragraph> 939cdf0e10cSrcweir</tablecell> 940cdf0e10cSrcweir</tablerow> 941cdf0e10cSrcweir<tablerow> 942cdf0e10cSrcweir<tablecell> 943*347184d5Smseidel<paragraph role="paragraph" id="par_id3153931" xml-lang="en-US" l10n="U">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph> 944cdf0e10cSrcweir</tablecell> 945cdf0e10cSrcweir</tablerow> 946cdf0e10cSrcweir<tablerow> 947cdf0e10cSrcweir<tablecell> 948*347184d5Smseidel<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8 [DBNum2]</paragraph> 949cdf0e10cSrcweir</tablecell> 950cdf0e10cSrcweir</tablerow> 951cdf0e10cSrcweir<tablerow> 952cdf0e10cSrcweir<tablecell> 953*347184d5Smseidel<paragraph role="paragraph" id="par_id3152976" xml-lang="en-US" l10n="U">[NatNum3] Transliteration in</paragraph> 954cdf0e10cSrcweir</tablecell> 955cdf0e10cSrcweir</tablerow> 956cdf0e10cSrcweir<tablerow> 957cdf0e10cSrcweir<tablecell> 958*347184d5Smseidel<paragraph role="paragraph" id="par_id3154353" xml-lang="en-US" l10n="U">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> 959cdf0e10cSrcweir</tablecell> 960cdf0e10cSrcweir</tablerow> 961cdf0e10cSrcweir<tablerow> 962cdf0e10cSrcweir<tablecell> 963*347184d5Smseidel<paragraph role="paragraph" id="par_id3154669" xml-lang="en-US" l10n="U">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph> 964cdf0e10cSrcweir</tablecell> 965cdf0e10cSrcweir</tablerow> 966cdf0e10cSrcweir<tablerow> 967cdf0e10cSrcweir<tablecell> 968*347184d5Smseidel<paragraph role="paragraph" id="par_id3150472" xml-lang="en-US" l10n="U">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3 [DBNum3]</paragraph> 969cdf0e10cSrcweir</tablecell> 970cdf0e10cSrcweir</tablerow> 971cdf0e10cSrcweir<tablerow> 972cdf0e10cSrcweir<tablecell> 973*347184d5Smseidel<paragraph role="paragraph" id="par_id3157811" xml-lang="en-US" l10n="U">[NatNum4] Transliteration in</paragraph> 974cdf0e10cSrcweir</tablecell> 975cdf0e10cSrcweir</tablerow> 976cdf0e10cSrcweir<tablerow> 977cdf0e10cSrcweir<tablecell> 978*347184d5Smseidel<paragraph role="paragraph" id="par_id3154592" xml-lang="en-US" l10n="U">Chinese: lower case text [DBNum1]</paragraph> 979cdf0e10cSrcweir</tablecell> 980cdf0e10cSrcweir</tablerow> 981cdf0e10cSrcweir<tablerow> 982cdf0e10cSrcweir<tablecell> 983*347184d5Smseidel<paragraph role="paragraph" id="par_id3150350" xml-lang="en-US" l10n="U">Japanese: modern long Kanji text [DBNum2]</paragraph> 984cdf0e10cSrcweir</tablecell> 985cdf0e10cSrcweir</tablerow> 986cdf0e10cSrcweir<tablerow> 987cdf0e10cSrcweir<tablecell> 988*347184d5Smseidel<paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U">Korean: formal lower case text</paragraph> 989cdf0e10cSrcweir</tablecell> 990cdf0e10cSrcweir</tablerow> 991cdf0e10cSrcweir<tablerow> 992cdf0e10cSrcweir<tablecell> 993*347184d5Smseidel<paragraph role="paragraph" id="par_id3153546" xml-lang="en-US" l10n="U">[NatNum5] Transliteration in</paragraph> 994cdf0e10cSrcweir</tablecell> 995cdf0e10cSrcweir</tablerow> 996cdf0e10cSrcweir<tablerow> 997cdf0e10cSrcweir<tablecell> 998*347184d5Smseidel<paragraph role="paragraph" id="par_id3155612" xml-lang="en-US" l10n="U">Chinese: Chinese upper case text [DBNum2]</paragraph> 999cdf0e10cSrcweir</tablecell> 1000cdf0e10cSrcweir</tablerow> 1001cdf0e10cSrcweir<tablerow> 1002cdf0e10cSrcweir<tablecell> 1003*347184d5Smseidel<paragraph role="paragraph" id="par_id3155909" xml-lang="en-US" l10n="U">Japanese: traditional long Kanji text [DBNum3]</paragraph> 1004cdf0e10cSrcweir</tablecell> 1005cdf0e10cSrcweir</tablerow> 1006cdf0e10cSrcweir<tablerow> 1007cdf0e10cSrcweir<tablecell> 1008*347184d5Smseidel<paragraph role="paragraph" id="par_id3151304" xml-lang="en-US" l10n="U">Korean: formal upper case text</paragraph> 1009cdf0e10cSrcweir</tablecell> 1010cdf0e10cSrcweir</tablerow> 1011cdf0e10cSrcweir<tablerow> 1012cdf0e10cSrcweir<tablecell> 1013*347184d5Smseidel<paragraph role="paragraph" id="par_id3155075" xml-lang="en-US" l10n="U">[NatNum6] Transliteration in</paragraph> 1014cdf0e10cSrcweir</tablecell> 1015cdf0e10cSrcweir</tablerow> 1016cdf0e10cSrcweir<tablerow> 1017cdf0e10cSrcweir<tablecell> 1018*347184d5Smseidel<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U">Chinese: fullwidth text [DBNum3]</paragraph> 1019cdf0e10cSrcweir</tablecell> 1020cdf0e10cSrcweir</tablerow> 1021cdf0e10cSrcweir<tablerow> 1022cdf0e10cSrcweir<tablecell> 1023*347184d5Smseidel<paragraph role="paragraph" id="par_id3154114" xml-lang="en-US" l10n="U">Japanese: fullwidth text</paragraph> 1024cdf0e10cSrcweir</tablecell> 1025cdf0e10cSrcweir</tablerow> 1026cdf0e10cSrcweir<tablerow> 1027cdf0e10cSrcweir<tablecell> 1028*347184d5Smseidel<paragraph role="paragraph" id="par_id3155344" xml-lang="en-US" l10n="U">Korean: fullwidth text</paragraph> 1029cdf0e10cSrcweir</tablecell> 1030cdf0e10cSrcweir</tablerow> 1031cdf0e10cSrcweir<tablerow> 1032cdf0e10cSrcweir<tablecell> 1033*347184d5Smseidel<paragraph role="paragraph" id="par_id3155538" xml-lang="en-US" l10n="U">[NatNum7] Transliteration in</paragraph> 1034cdf0e10cSrcweir</tablecell> 1035cdf0e10cSrcweir</tablerow> 1036cdf0e10cSrcweir<tablerow> 1037cdf0e10cSrcweir<tablecell> 1038*347184d5Smseidel<paragraph role="paragraph" id="par_id3145123" xml-lang="en-US" l10n="U">Japanese: modern short Kanji text</paragraph> 1039cdf0e10cSrcweir</tablecell> 1040cdf0e10cSrcweir</tablerow> 1041cdf0e10cSrcweir<tablerow> 1042cdf0e10cSrcweir<tablecell> 1043*347184d5Smseidel<paragraph role="paragraph" id="par_id3149424" xml-lang="en-US" l10n="U">Korean: informal lower case text</paragraph> 1044cdf0e10cSrcweir</tablecell> 1045cdf0e10cSrcweir</tablerow> 1046cdf0e10cSrcweir<tablerow> 1047cdf0e10cSrcweir<tablecell> 1048*347184d5Smseidel<paragraph role="paragraph" id="par_id3153688" xml-lang="en-US" l10n="U">[NatNum8] Transliteration in</paragraph> 1049cdf0e10cSrcweir</tablecell> 1050cdf0e10cSrcweir</tablerow> 1051cdf0e10cSrcweir<tablerow> 1052cdf0e10cSrcweir<tablecell> 1053*347184d5Smseidel<paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="U">Japanese: traditional short Kanji text [DBNum4]</paragraph> 1054cdf0e10cSrcweir</tablecell> 1055cdf0e10cSrcweir</tablerow> 1056cdf0e10cSrcweir<tablerow> 1057cdf0e10cSrcweir<tablecell> 1058*347184d5Smseidel<paragraph role="paragraph" id="par_id3145602" xml-lang="en-US" l10n="U">Korean: informal upper case text</paragraph> 1059cdf0e10cSrcweir</tablecell> 1060cdf0e10cSrcweir</tablerow> 1061cdf0e10cSrcweir<tablerow> 1062cdf0e10cSrcweir<tablecell> 1063*347184d5Smseidel<paragraph role="paragraph" id="par_id3159228" xml-lang="en-US" l10n="U">[NatNum9] Transliteration in</paragraph> 1064cdf0e10cSrcweir</tablecell> 1065cdf0e10cSrcweir</tablerow> 1066cdf0e10cSrcweir<tablerow> 1067cdf0e10cSrcweir<tablecell> 1068*347184d5Smseidel<paragraph role="paragraph" id="par_id3154644" xml-lang="en-US" l10n="U">Korean: Hangul characters</paragraph> 1069cdf0e10cSrcweir</tablecell> 1070cdf0e10cSrcweir</tablerow> 1071cdf0e10cSrcweir<tablerow> 1072cdf0e10cSrcweir<tablecell> 1073*347184d5Smseidel<paragraph role="paragraph" id="par_id3155396" xml-lang="en-US" l10n="U">[NatNum10] Transliteration in</paragraph> 1074cdf0e10cSrcweir</tablecell> 1075cdf0e10cSrcweir</tablerow> 1076cdf0e10cSrcweir<tablerow> 1077cdf0e10cSrcweir<tablecell> 1078*347184d5Smseidel<paragraph role="paragraph" id="par_id3150878" xml-lang="en-US" l10n="U">Korean: formal Hangul text [DBNum4]; CAL: 9/11/11 [DBNum4]</paragraph> 1079cdf0e10cSrcweir</tablecell> 1080cdf0e10cSrcweir</tablerow> 1081cdf0e10cSrcweir<tablerow> 1082cdf0e10cSrcweir<tablecell> 1083*347184d5Smseidel<paragraph role="paragraph" id="par_id3149384" xml-lang="en-US" l10n="U">[NatNum11] Transliteration in</paragraph> 1084cdf0e10cSrcweir</tablecell> 1085cdf0e10cSrcweir</tablerow> 1086cdf0e10cSrcweir<tablerow> 1087cdf0e10cSrcweir<tablecell> 1088*347184d5Smseidel<paragraph role="paragraph" id="par_id3154213" xml-lang="en-US" l10n="U">Korean: informal Hangul text</paragraph> 1089cdf0e10cSrcweir</tablecell> 1090cdf0e10cSrcweir</tablerow> 1091cdf0e10cSrcweir</table> 1092cdf0e10cSrcweir</body> 1093cdf0e10cSrcweir</helpdocument> 1094