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