| blob | 567c64a43bc1edc870e1811202bfd01421a29195 |
4 <!--
5 ***********************************************************************
6 *
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 *
9 * Copyright 2008 by Sun Microsystems, Inc.
10 *
11 * OpenOffice.org - a multi-platform office productivity suite
12 *
13 * $RCSfile: 05020301.xhp,v $
14 * $Revision: 1.13.4.1 $
15 *
16 * This file is part of OpenOffice.org.
17 *
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
21 *
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
27 *
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
32 *
33 ************************************************************************
34 -->
37 <meta>
41 </topic>
42 </meta>
43 <body>
44 <bookmark xml-lang="en-US" branch="index" id="bm_id3153514"><bookmark_value>format codes; numbers</bookmark_value>
54 <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>
55 </variable></paragraph>
56 <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>
58 <listitem>
59 <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>
60 </listitem>
61 <listitem>
62 <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>
63 </listitem>
64 </list>
66 <listitem>
67 <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>
68 </listitem>
69 </list>
70 <paragraph role="heading" id="hd_id3151262" xml-lang="en-US" level="2" l10n="U" oldref="229">Decimal Places and Significant Digits</paragraph>
71 <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>
72 <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>
73 <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>
75 <tablerow>
76 <tablecell>
77 <paragraph role="tablehead" id="par_id3150902" xml-lang="en-US" l10n="U" oldref="86">Placeholders</paragraph>
78 </tablecell>
79 <tablecell>
80 <paragraph role="tablehead" id="par_id3157896" xml-lang="en-US" l10n="U" oldref="87">Explanation</paragraph>
81 </tablecell>
82 </tablerow>
83 <tablerow>
84 <tablecell>
86 </tablecell>
87 <tablecell>
88 <paragraph role="tablecontent" id="par_id3145090" xml-lang="en-US" l10n="U" oldref="6">Does not display extra zeros.</paragraph>
89 </tablecell>
90 </tablerow>
91 <tablerow>
92 <tablecell>
93 <paragraph role="code" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="7">0 (Zero)</paragraph>
94 </tablecell>
95 <tablecell>
96 <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>
97 </tablecell>
98 </tablerow>
99 </table>
101 <paragraph role="heading" id="par_idN1087E" xml-lang="en-US" level="3" l10n="NEW">Examples</paragraph>
103 <tablerow>
104 <tablecell>
105 <paragraph role="tablehead" id="par_id3149182" xml-lang="en-US" l10n="U" oldref="9">Number Format</paragraph>
106 </tablecell>
107 <tablecell>
108 <paragraph role="tablehead" id="par_id3154749" xml-lang="en-US" l10n="U" oldref="10">Format Code</paragraph>
109 </tablecell>
110 </tablerow>
111 <tablerow>
112 <tablecell>
113 <paragraph role="tablecontent" id="par_id3148538" xml-lang="en-US" l10n="U" oldref="11">3456.78 as 3456.8</paragraph>
114 </tablecell>
115 <tablecell>
116 <paragraph role="code" id="par_id3150355" xml-lang="en-US" l10n="U" oldref="12">####.#</paragraph>
117 </tablecell>
118 </tablerow>
119 <tablerow>
120 <tablecell>
121 <paragraph role="tablecontent" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="13">9.9 as 9.900</paragraph>
122 </tablecell>
123 <tablecell>
124 <paragraph role="code" id="par_id3159256" xml-lang="en-US" l10n="U" oldref="14">#.000</paragraph>
125 </tablecell>
126 </tablerow>
127 <tablerow>
128 <tablecell>
129 <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>
130 </tablecell>
131 <tablecell>
132 <paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U" oldref="16">#.0#</paragraph>
133 </tablecell>
134 </tablerow>
135 <tablerow>
136 <tablecell>
137 <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>
138 </tablecell>
139 <tablecell>
140 <paragraph role="code" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="18"># ???/???</paragraph>
141 </tablecell>
142 </tablerow>
143 <tablerow>
144 <tablecell>
145 <paragraph role="tablecontent" id="par_id3156152" xml-lang="en-US" l10n="U" oldref="19">.5 as 0.5</paragraph>
146 </tablecell>
147 <tablecell>
148 <paragraph role="code" id="par_id3149762" xml-lang="en-US" l10n="U" oldref="20">0.##</paragraph>
149 </tablecell>
150 </tablerow>
151 </table>
153 <paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3" l10n="U" oldref="230">Thousands Separator</paragraph>
154 <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>
156 <tablerow>
157 <tablecell>
158 <paragraph role="tablehead" id="par_id3154905" xml-lang="en-US" l10n="U" oldref="22">Number Format</paragraph>
159 </tablecell>
160 <tablecell>
161 <paragraph role="tablehead" id="par_id3150822" xml-lang="en-US" l10n="U" oldref="23">Format Code</paragraph>
162 </tablecell>
163 </tablerow>
164 <tablerow>
165 <tablecell>
166 <paragraph role="tablecontent" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="24">15000 as 15,000</paragraph>
167 </tablecell>
168 <tablecell>
169 <paragraph role="code" id="par_id3151223" xml-lang="en-US" l10n="U" oldref="25">#,###</paragraph>
170 </tablecell>
171 </tablerow>
172 <tablerow>
173 <tablecell>
174 <paragraph role="tablecontent" id="par_id3154935" xml-lang="en-US" l10n="U" oldref="26">16000 as 16</paragraph>
175 </tablecell>
176 <tablecell>
178 </tablecell>
179 </tablerow>
180 </table>
182 <paragraph role="heading" id="hd_id3154836" xml-lang="en-US" level="2" l10n="U" oldref="79">Including Text in Number Format Codes</paragraph>
183 <paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="3" l10n="U" oldref="231">Text and Numbers</paragraph>
184 <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>
185 <paragraph role="heading" id="hd_id3148979" xml-lang="en-US" level="3" l10n="U" oldref="232">Text and Text</paragraph>
186 <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>
187 <paragraph role="heading" id="hd_id3154330" xml-lang="en-US" level="3" l10n="U" oldref="233">Spaces</paragraph>
188 <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>
189 <paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="2" l10n="U" oldref="234">Color</paragraph>
190 <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>
192 <tablerow>
193 <tablecell>
194 <paragraph role="code" id="par_id3154630" xml-lang="en-US" l10n="U" oldref="29">CYAN</paragraph>
195 </tablecell>
196 <tablecell>
197 <paragraph role="code" id="par_id3148676" xml-lang="en-US" l10n="U" oldref="30">GREEN</paragraph>
198 </tablecell>
199 </tablerow>
200 <tablerow>
201 <tablecell>
202 <paragraph role="code" id="par_id3154123" xml-lang="en-US" l10n="U" oldref="31">BLACK</paragraph>
203 </tablecell>
204 <tablecell>
205 <paragraph role="code" id="par_id3149167" xml-lang="en-US" l10n="U" oldref="32">BLUE</paragraph>
206 </tablecell>
207 </tablerow>
208 <tablerow>
209 <tablecell>
210 <paragraph role="code" id="par_id3158407" xml-lang="en-US" l10n="U" oldref="33">MAGENTA</paragraph>
211 </tablecell>
212 <tablecell>
214 </tablecell>
215 </tablerow>
216 <tablerow>
217 <tablecell>
218 <paragraph role="code" id="par_id3147502" xml-lang="en-US" l10n="U" oldref="35">WHITE</paragraph>
219 </tablecell>
220 <tablecell>
221 <paragraph role="code" id="par_id3153368" xml-lang="en-US" l10n="U" oldref="36">YELLOW</paragraph>
222 </tablecell>
223 </tablerow>
224 </table>
226 <paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2" l10n="U" oldref="111">Conditions</paragraph>
227 <paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="3" l10n="U" oldref="235">Conditional Brackets</paragraph>
228 <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>
229 <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>
230 <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>
231 <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>
232 <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>
233 <paragraph role="heading" id="hd_id3154833" xml-lang="en-US" level="3" l10n="U" oldref="90">Positive and Negative Numbers</paragraph>
234 <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>
235 <paragraph role="example" id="par_id3153727" xml-lang="en-US" l10n="U" oldref="92">"plus" 0;"minus" 0;"null" 0</paragraph>
236 <paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2" l10n="U" oldref="83">Percentages and Scientific Notation</paragraph>
237 <paragraph role="heading" id="hd_id3147218" xml-lang="en-US" level="3" l10n="U" oldref="237">Percentages</paragraph>
238 <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>
239 <paragraph role="heading" id="hd_id3156005" xml-lang="en-US" level="3" l10n="U" oldref="89">Scientific Notation</paragraph>
240 <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>
241 <paragraph role="heading" id="hd_id3159080" xml-lang="en-US" level="2" l10n="U" oldref="98">Number Format Codes of Currency Formats</paragraph>
242 <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>
243 <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>
245 <paragraph role="heading" id="hd_id3157309" xml-lang="en-US" level="2" l10n="U" oldref="238">Date and Time Formats</paragraph>
246 <paragraph role="heading" id="hd_id3153740" xml-lang="en-US" level="3" l10n="U" oldref="37">Date Formats</paragraph>
247 <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>
248 <paragraph role="warning" id="par_id610980" xml-lang="en-US" l10n="NEW">Not all format codes give meaningful results for all languages.</paragraph>
250 <tablerow>
251 <tablecell>
252 <paragraph role="tablehead" id="par_id3152376" xml-lang="en-US" l10n="U" oldref="39">Format</paragraph>
253 </tablecell>
254 <tablecell>
255 <paragraph role="tablehead" id="par_id3159130" xml-lang="en-US" l10n="U" oldref="40">Format Code</paragraph>
256 </tablecell>
257 </tablerow>
258 <tablerow>
259 <tablecell>
260 <paragraph role="tablecontent" id="par_id3147380" xml-lang="en-US" l10n="U" oldref="41">Month as 3.</paragraph>
261 </tablecell>
262 <tablecell>
264 </tablecell>
265 </tablerow>
266 <tablerow>
267 <tablecell>
268 <paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U" oldref="43">Month as 03.</paragraph>
269 </tablecell>
270 <tablecell>
272 </tablecell>
273 </tablerow>
274 <tablerow>
275 <tablecell>
276 <paragraph role="tablecontent" id="par_id3145728" xml-lang="en-US" l10n="U" oldref="45">Month as Jan-Dec</paragraph>
277 </tablecell>
278 <tablecell>
280 </tablecell>
281 </tablerow>
282 <tablerow>
283 <tablecell>
284 <paragraph role="tablecontent" id="par_id3149909" xml-lang="en-US" l10n="U" oldref="47">Month as January-December</paragraph>
285 </tablecell>
286 <tablecell>
287 <paragraph role="code" id="par_id3155318" xml-lang="en-US" l10n="U" oldref="48">MMMM</paragraph>
288 </tablecell>
289 </tablerow>
290 <tablerow>
291 <tablecell>
292 <paragraph role="tablecontent" id="par_id3151218" xml-lang="en-US" l10n="U" oldref="116">First letter of Name of Month</paragraph>
293 </tablecell>
294 <tablecell>
295 <paragraph role="code" id="par_id3150420" xml-lang="en-US" l10n="U" oldref="117">MMMMM</paragraph>
296 </tablecell>
297 </tablerow>
298 <tablerow>
299 <tablecell>
300 <paragraph role="tablecontent" id="par_id3154501" xml-lang="en-US" l10n="U" oldref="49">Day as 2</paragraph>
301 </tablecell>
302 <tablecell>
304 </tablecell>
305 </tablerow>
306 <tablerow>
307 <tablecell>
308 <paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="51">Day as 02</paragraph>
309 </tablecell>
310 <tablecell>
312 </tablecell>
313 </tablerow>
314 <tablerow>
315 <tablecell>
316 <paragraph role="tablecontent" id="par_id3148495" xml-lang="en-US" l10n="U" oldref="53">Day as Sun-Sat</paragraph>
317 </tablecell>
318 <tablecell>
319 <paragraph role="code" id="par_id3161665" xml-lang="en-US" l10n="U" oldref="54">NN or DDD</paragraph>
320 </tablecell>
321 </tablerow>
322 <tablerow>
323 <tablecell>
324 <paragraph role="tablecontent" id="par_id3154272" xml-lang="en-US" l10n="U" oldref="118">Day as Sunday to Saturday</paragraph>
325 </tablecell>
326 <tablecell>
327 <paragraph role="code" id="par_id3145164" xml-lang="en-US" l10n="U" oldref="119">NNN or DDDD</paragraph>
328 </tablecell>
329 </tablerow>
330 <tablerow>
331 <tablecell>
332 <paragraph role="tablecontent" id="par_id3146791" xml-lang="en-US" l10n="U" oldref="55">Day followed by comma, as in "Sunday,"</paragraph>
333 </tablecell>
334 <tablecell>
335 <paragraph role="code" id="par_id3146081" xml-lang="en-US" l10n="U" oldref="56">NNNN</paragraph>
336 </tablecell>
337 </tablerow>
338 <tablerow>
339 <tablecell>
340 <paragraph role="tablecontent" id="par_id3156275" xml-lang="en-US" l10n="U" oldref="57">Year as 00-99</paragraph>
341 </tablecell>
342 <tablecell>
344 </tablecell>
345 </tablerow>
346 <tablerow>
347 <tablecell>
348 <paragraph role="tablecontent" id="par_id3148408" xml-lang="en-US" l10n="U" oldref="59">Year as 1900-2078</paragraph>
349 </tablecell>
350 <tablecell>
351 <paragraph role="code" id="par_id3151358" xml-lang="en-US" l10n="U" oldref="60">YYYY</paragraph>
352 </tablecell>
353 </tablerow>
354 <tablerow>
355 <tablecell>
356 <paragraph role="tablecontent" id="par_id3153355" xml-lang="en-US" l10n="U" oldref="96">Calendar week</paragraph>
357 </tablecell>
358 <tablecell>
360 </tablecell>
361 </tablerow>
362 <tablerow>
363 <tablecell>
364 <paragraph role="tablecontent" id="par_id3154302" xml-lang="en-US" l10n="U" oldref="103">Quarterly as Q1 to Q4</paragraph>
365 </tablecell>
366 <tablecell>
367 <paragraph role="code" id="par_id3159266" xml-lang="en-US" l10n="CHG" oldref="104">Q</paragraph>
368 </tablecell>
369 </tablerow>
370 <tablerow>
371 <tablecell>
372 <paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U" oldref="105">Quarterly as 1st quarter to 4th quarter</paragraph>
373 </tablecell>
374 <tablecell>
376 </tablecell>
377 </tablerow>
378 <tablerow>
379 <tablecell>
380 <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>
381 </tablecell>
382 <tablecell>
384 </tablecell>
385 </tablerow>
386 <tablerow>
387 <tablecell>
388 <paragraph role="tablecontent" id="par_id3163806" xml-lang="en-US" l10n="U" oldref="122">Era, abbreviation</paragraph>
389 </tablecell>
390 <tablecell>
392 </tablecell>
393 </tablerow>
394 <tablerow>
395 <tablecell>
396 <paragraph role="tablecontent" id="par_id3151187" xml-lang="en-US" l10n="U" oldref="124">Era, full name</paragraph>
397 </tablecell>
398 <tablecell>
399 <paragraph role="code" id="par_id3149568" xml-lang="en-US" l10n="U" oldref="125">GGG</paragraph>
400 </tablecell>
401 </tablerow>
402 <tablerow>
403 <tablecell>
404 <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>
405 </tablecell>
406 <tablecell>
408 </tablecell>
409 </tablerow>
410 <tablerow>
411 <tablecell>
412 <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>
413 </tablecell>
414 <tablecell>
415 <paragraph role="code" id="par_id3150298" xml-lang="en-US" l10n="U" oldref="129">EE or R</paragraph>
416 </tablecell>
417 </tablerow>
418 <tablerow>
419 <tablecell>
420 <paragraph role="tablecontent" id="par_id3152861" xml-lang="en-US" l10n="U" oldref="138">Era, full name and year</paragraph>
421 </tablecell>
422 <tablecell>
423 <paragraph role="code" id="par_id3149926" xml-lang="en-US" l10n="U" oldref="139">RR or GGGEE</paragraph>
424 </tablecell>
425 </tablerow>
426 </table>
428 <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>
429 <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>
431 <tablerow>
432 <tablecell>
433 <paragraph role="tablehead" id="par_id1002200811563044" xml-lang="en-US" l10n="NEW">Locale</paragraph>
434 </tablecell>
435 <tablecell>
436 <paragraph role="tablehead" id="par_id1002200811563137" xml-lang="en-US" l10n="NEW">Year</paragraph>
437 </tablecell>
438 <tablecell>
439 <paragraph role="tablehead" id="par_id1002200811563164" xml-lang="en-US" l10n="NEW">Month</paragraph>
440 </tablecell>
441 <tablecell>
442 <paragraph role="tablehead" id="par_id1002200811563128" xml-lang="en-US" l10n="NEW">Day</paragraph>
443 </tablecell>
444 <tablecell>
445 <paragraph role="tablehead" id="par_id1002200811563135" xml-lang="en-US" l10n="NEW">Hour</paragraph>
446 </tablecell>
447 <tablecell>
448 <paragraph role="tablehead" id="par_id1002200811563289" xml-lang="en-US" l10n="NEW">Day Of Week</paragraph>
449 </tablecell>
450 <tablecell>
451 <paragraph role="tablehead" id="par_id100220081156322" xml-lang="en-US" l10n="NEW">Era</paragraph>
452 </tablecell>
453 </tablerow>
454 <tablerow>
455 <tablecell>
456 <paragraph role="tablecontent" id="par_id1002200811563233" xml-lang="en-US" l10n="NEW">English - en</paragraph>
457 <paragraph role="tablecontent" id="par_id1002200811563243" xml-lang="en-US" l10n="NEW">and all not listed locales</paragraph>
458 </tablecell>
459 <tablecell>
460 <paragraph role="tablecontent" id="par_id1002200811563352" xml-lang="en-US" l10n="NEW">Y</paragraph>
461 </tablecell>
462 <tablecell>
463 <paragraph role="tablecontent" id="par_id1002200811563396" xml-lang="en-US" l10n="NEW">M</paragraph>
464 </tablecell>
465 <tablecell>
466 <paragraph role="tablecontent" id="par_id1002200811563385" xml-lang="en-US" l10n="NEW">D</paragraph>
467 </tablecell>
468 <tablecell>
469 <paragraph role="tablecontent" id="par_id1002200811563472" xml-lang="en-US" l10n="NEW">H</paragraph>
470 </tablecell>
471 <tablecell>
472 <paragraph role="tablecontent" id="par_id1002200811563430" xml-lang="en-US" l10n="NEW">A</paragraph>
473 </tablecell>
474 <tablecell>
475 <paragraph role="tablecontent" id="par_id1002200811563488" xml-lang="en-US" l10n="NEW">G</paragraph>
476 </tablecell>
477 </tablerow>
478 <tablerow>
479 <tablecell>
480 <paragraph role="tablecontent" id="par_id1002200811563484" xml-lang="en-US" l10n="NEW">German - de</paragraph>
481 </tablecell>
482 <tablecell>
483 <paragraph role="tablecontent" id="par_id1002200811563518" xml-lang="en-US" l10n="NEW">J</paragraph>
484 </tablecell>
485 <tablecell>
486 </tablecell>
487 <tablecell>
488 <paragraph role="tablecontent" id="par_id1002200811563735" xml-lang="en-US" l10n="NEW">T</paragraph>
489 </tablecell>
490 <tablecell>
491 </tablecell>
492 <tablecell>
493 </tablecell>
494 <tablecell>
495 </tablecell>
496 </tablerow>
497 <tablerow>
498 <tablecell>
499 <paragraph role="tablecontent" id="par_id1002200811563823" xml-lang="en-US" l10n="NEW">Netherlands - nl</paragraph>
500 </tablecell>
501 <tablecell>
502 <paragraph role="tablecontent" id="par_id1002200811563852" xml-lang="en-US" l10n="NEW">J</paragraph>
503 </tablecell>
504 <tablecell>
505 </tablecell>
506 <tablecell>
507 </tablecell>
508 <tablecell>
509 <paragraph role="tablecontent" id="par_id1002200811563827" xml-lang="en-US" l10n="NEW">U</paragraph>
510 </tablecell>
511 <tablecell>
512 </tablecell>
513 <tablecell>
514 </tablecell>
515 </tablerow>
516 <tablerow>
517 <tablecell>
518 <paragraph role="tablecontent" id="par_id1002200811563916" xml-lang="en-US" l10n="NEW">French - fr</paragraph>
519 </tablecell>
520 <tablecell>
521 <paragraph role="tablecontent" id="par_id1002200811563970" xml-lang="en-US" l10n="NEW">A</paragraph>
522 </tablecell>
523 <tablecell>
524 </tablecell>
525 <tablecell>
526 <paragraph role="tablecontent" id="par_id1002200811563980" xml-lang="en-US" l10n="NEW">J</paragraph>
527 </tablecell>
528 <tablecell>
529 </tablecell>
530 <tablecell>
531 <paragraph role="tablecontent" id="par_id1002200811564065" xml-lang="en-US" l10n="NEW">O</paragraph>
532 </tablecell>
533 <tablecell>
534 </tablecell>
535 </tablerow>
536 <tablerow>
537 <tablecell>
538 <paragraph role="tablecontent" id="par_id100220081156407" xml-lang="en-US" l10n="NEW">Italian - it</paragraph>
539 </tablecell>
540 <tablecell>
541 <paragraph role="tablecontent" id="par_id100220081156403" xml-lang="en-US" l10n="NEW">A</paragraph>
542 </tablecell>
543 <tablecell>
544 </tablecell>
545 <tablecell>
546 <paragraph role="tablecontent" id="par_id1002200811564042" xml-lang="en-US" l10n="NEW">G</paragraph>
547 </tablecell>
548 <tablecell>
549 </tablecell>
550 <tablecell>
551 <paragraph role="tablecontent" id="par_id100220081156412" xml-lang="en-US" l10n="NEW">O</paragraph>
552 </tablecell>
553 <tablecell>
554 <paragraph role="tablecontent" id="par_id1002200811564119" xml-lang="en-US" l10n="NEW">X</paragraph>
555 </tablecell>
556 </tablerow>
557 <tablerow>
558 <tablecell>
559 <paragraph role="tablecontent" id="par_id1002200811564197" xml-lang="en-US" l10n="NEW">Portuguese - pt</paragraph>
560 </tablecell>
561 <tablecell>
562 <paragraph role="tablecontent" id="par_id1002200811564272" xml-lang="en-US" l10n="NEW">A</paragraph>
563 </tablecell>
564 <tablecell>
565 </tablecell>
566 <tablecell>
567 </tablecell>
568 <tablecell>
569 </tablecell>
570 <tablecell>
571 <paragraph role="tablecontent" id="par_id100220081156423" xml-lang="en-US" l10n="NEW">O</paragraph>
572 </tablecell>
573 <tablecell>
574 </tablecell>
575 </tablerow>
576 <tablerow>
577 <tablecell>
578 <paragraph role="tablecontent" id="par_id1002200811564218" xml-lang="en-US" l10n="NEW">Spanish - es</paragraph>
579 </tablecell>
580 <tablecell>
581 <paragraph role="tablecontent" id="par_id1002200811564390" xml-lang="en-US" l10n="NEW">A</paragraph>
582 </tablecell>
583 <tablecell>
584 </tablecell>
585 <tablecell>
586 </tablecell>
587 <tablecell>
588 </tablecell>
589 <tablecell>
590 <paragraph role="tablecontent" id="par_id1002200811564319" xml-lang="en-US" l10n="NEW">O</paragraph>
591 </tablecell>
592 <tablecell>
593 </tablecell>
594 </tablerow>
595 <tablerow>
596 <tablecell>
597 <paragraph role="tablecontent" id="par_id100220081156433" xml-lang="en-US" l10n="NEW">Danish - da</paragraph>
598 </tablecell>
599 <tablecell>
600 </tablecell>
601 <tablecell>
602 </tablecell>
603 <tablecell>
604 </tablecell>
605 <tablecell>
606 <paragraph role="tablecontent" id="par_id100220081156444" xml-lang="en-US" l10n="NEW">T</paragraph>
607 </tablecell>
608 <tablecell>
609 </tablecell>
610 <tablecell>
611 </tablecell>
612 </tablerow>
613 <tablerow>
614 <tablecell>
615 <paragraph role="tablecontent" id="par_id1002200811564448" xml-lang="en-US" l10n="NEW">Norwegian - no, nb, nn</paragraph>
616 </tablecell>
617 <tablecell>
618 </tablecell>
619 <tablecell>
620 </tablecell>
621 <tablecell>
622 </tablecell>
623 <tablecell>
624 <paragraph role="tablecontent" id="par_id1002200811564549" xml-lang="en-US" l10n="NEW">T</paragraph>
625 </tablecell>
626 <tablecell>
627 </tablecell>
628 <tablecell>
629 </tablecell>
630 </tablerow>
631 <tablerow>
632 <tablecell>
633 <paragraph role="tablecontent" id="par_id1002200811564565" xml-lang="en-US" l10n="NEW">Swedish - sv</paragraph>
634 </tablecell>
635 <tablecell>
636 </tablecell>
637 <tablecell>
638 </tablecell>
639 <tablecell>
640 </tablecell>
641 <tablecell>
642 <paragraph role="tablecontent" id="par_id1002200811564556" xml-lang="en-US" l10n="NEW">T</paragraph>
643 </tablecell>
644 <tablecell>
645 </tablecell>
646 <tablecell>
647 </tablecell>
648 </tablerow>
649 <tablerow>
650 <tablecell>
651 <paragraph role="tablecontent" id="par_id1002200811564637" xml-lang="en-US" l10n="NEW">Finnish - fi</paragraph>
652 </tablecell>
653 <tablecell>
654 <paragraph role="tablecontent" id="par_id1002200811564627" xml-lang="en-US" l10n="NEW">V</paragraph>
655 </tablecell>
656 <tablecell>
657 <paragraph role="tablecontent" id="par_id1002200811564643" xml-lang="en-US" l10n="NEW">K</paragraph>
658 </tablecell>
659 <tablecell>
660 <paragraph role="tablecontent" id="par_id1002200811564763" xml-lang="en-US" l10n="NEW">P</paragraph>
661 </tablecell>
662 <tablecell>
663 <paragraph role="tablecontent" id="par_id1002200811564715" xml-lang="en-US" l10n="NEW">T</paragraph>
664 </tablecell>
665 <tablecell>
666 </tablecell>
667 <tablecell>
668 </tablecell>
669 </tablerow>
670 </table>
672 <paragraph role="heading" id="hd_id3149929" xml-lang="en-US" level="3" l10n="U" oldref="227">Entering Dates</paragraph>
673 <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>
674 <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>Tools - Options - Language settings - Languages</emph>. For example, if your locale is set to 'Japanese', then the Gengou calendar is used. The default date format in <item type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph>
675 <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>
677 <tablerow>
678 <tablecell>
679 <paragraph role="tablehead" id="par_id3145764" xml-lang="en-US" l10n="U" oldref="217">Modifier</paragraph>
680 </tablecell>
681 <tablecell>
682 <paragraph role="tablehead" id="par_id3152967" xml-lang="en-US" l10n="U" oldref="218">Calendar</paragraph>
683 </tablecell>
684 </tablerow>
685 <tablerow>
686 <tablecell>
687 <paragraph role="code" id="par_id3148390" xml-lang="en-US" l10n="U" oldref="219">[~buddhist]</paragraph>
688 </tablecell>
689 <tablecell>
690 <paragraph role="tablecontent" id="par_id3153781" xml-lang="en-US" l10n="U" oldref="220">Thai Buddhist Calendar</paragraph>
691 </tablecell>
692 </tablerow>
693 <tablerow>
694 <tablecell>
695 <paragraph role="code" id="par_id3157969" xml-lang="en-US" l10n="U" oldref="133">[~gengou]</paragraph>
696 </tablecell>
697 <tablecell>
698 <paragraph role="tablecontent" id="par_id3154656" xml-lang="en-US" l10n="U" oldref="134">Japanese Gengou Calendar</paragraph>
699 </tablecell>
700 </tablerow>
701 <tablerow>
702 <tablecell>
703 <paragraph role="code" id="par_id3150086" xml-lang="en-US" l10n="U" oldref="131">[~gregorian]</paragraph>
704 </tablecell>
705 <tablecell>
706 <paragraph role="tablecontent" id="par_id3146070" xml-lang="en-US" l10n="U" oldref="132">Gregorian Calendar</paragraph>
707 </tablecell>
708 </tablerow>
709 <tablerow>
710 <tablecell>
711 <paragraph role="code" id="par_id3146808" xml-lang="en-US" l10n="U" oldref="221">[~hanja] or [~hanja_yoil]</paragraph>
712 </tablecell>
713 <tablecell>
714 <paragraph role="tablecontent" id="par_id3149207" xml-lang="en-US" l10n="U" oldref="136">Korean Calendar</paragraph>
715 </tablecell>
716 </tablerow>
717 <tablerow>
718 <tablecell>
719 <paragraph role="code" id="par_id3150304" xml-lang="en-US" l10n="U" oldref="222">[~hijri]</paragraph>
720 </tablecell>
721 <tablecell>
722 <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>
723 </tablecell>
724 </tablerow>
725 <tablerow>
726 <tablecell>
727 <paragraph role="code" id="par_id3154903" xml-lang="en-US" l10n="U" oldref="224">[~jewish]</paragraph>
728 </tablecell>
729 <tablecell>
730 <paragraph role="tablecontent" id="par_id3151288" xml-lang="en-US" l10n="U" oldref="225">Jewish Calendar</paragraph>
731 </tablecell>
732 </tablerow>
733 <tablerow>
734 <tablecell>
735 <paragraph role="code" id="par_id3166442" xml-lang="en-US" l10n="U" oldref="135">[~ROC]</paragraph>
736 </tablecell>
737 <tablecell>
738 <paragraph role="tablecontent" id="par_id3145587" xml-lang="en-US" l10n="U" oldref="226">Republic Of China Calendar</paragraph>
739 </tablecell>
740 </tablerow>
741 </table>
743 <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:
744 </caseinline></switchinline></paragraph>
748 <tablerow>
749 <tablecell>
750 <paragraph role="tablehead" id="par_id3154194" xml-lang="en-US" l10n="U" oldref="141">Initial Format</paragraph>
751 </tablecell>
752 <tablecell>
753 <paragraph role="tablehead" id="par_id3149787" xml-lang="en-US" l10n="U" oldref="142">Result Format</paragraph>
754 </tablecell>
755 </tablerow>
756 <tablerow>
757 <tablecell>
758 <paragraph role="tablecontent" id="par_id3152993" xml-lang="en-US" l10n="U" oldref="143">Date + Date</paragraph>
759 </tablecell>
760 <tablecell>
761 <paragraph role="tablecontent" id="par_id3150292" xml-lang="en-US" l10n="U" oldref="144">Number (Days)</paragraph>
762 </tablecell>
763 </tablerow>
764 <tablerow>
765 <tablecell>
766 <paragraph role="tablecontent" id="par_id3150460" xml-lang="en-US" l10n="U" oldref="145">Date + Number</paragraph>
767 </tablecell>
768 <tablecell>
769 <paragraph role="tablecontent" id="par_id3154371" xml-lang="en-US" l10n="U" oldref="146">Date</paragraph>
770 </tablecell>
771 </tablerow>
772 <tablerow>
773 <tablecell>
774 <paragraph role="tablecontent" id="par_id3145082" xml-lang="en-US" l10n="U" oldref="147">Date + Time</paragraph>
775 </tablecell>
776 <tablecell>
777 <paragraph role="tablecontent" id="par_id3156290" xml-lang="en-US" l10n="U" oldref="148">Date&Time</paragraph>
778 </tablecell>
779 </tablerow>
780 <tablerow>
781 <tablecell>
782 <paragraph role="tablecontent" id="par_id3152456" xml-lang="en-US" l10n="U" oldref="149">Date + Date&Time</paragraph>
783 </tablecell>
784 <tablecell>
785 <paragraph role="tablecontent" id="par_id3156169" xml-lang="en-US" l10n="U" oldref="150">Number</paragraph>
786 </tablecell>
787 </tablerow>
788 <tablerow>
789 <tablecell>
790 <paragraph role="tablecontent" id="par_id3154527" xml-lang="en-US" l10n="U" oldref="151">Time + Time</paragraph>
791 </tablecell>
792 <tablecell>
793 <paragraph role="tablecontent" id="par_id3159625" xml-lang="en-US" l10n="U" oldref="152">Time</paragraph>
794 </tablecell>
795 </tablerow>
796 <tablerow>
797 <tablecell>
798 <paragraph role="tablecontent" id="par_id3146802" xml-lang="en-US" l10n="U" oldref="153">Time + Number</paragraph>
799 </tablecell>
800 <tablecell>
801 <paragraph role="tablecontent" id="par_id3146770" xml-lang="en-US" l10n="U" oldref="154">Time</paragraph>
802 </tablecell>
803 </tablerow>
804 <tablerow>
805 <tablecell>
806 <paragraph role="tablecontent" id="par_id3155500" xml-lang="en-US" l10n="U" oldref="155">Time + Date&Time</paragraph>
807 </tablecell>
808 <tablecell>
809 <paragraph role="tablecontent" id="par_id3155128" xml-lang="en-US" l10n="U" oldref="156">Date&Time</paragraph>
810 </tablecell>
811 </tablerow>
812 <tablerow>
813 <tablecell>
814 <paragraph role="tablecontent" id="par_id3152904" xml-lang="en-US" l10n="U" oldref="157">Date&Time + Date&Time</paragraph>
815 </tablecell>
816 <tablecell>
817 <paragraph role="tablecontent" id="par_id3159143" xml-lang="en-US" l10n="U" oldref="158">Time</paragraph>
818 </tablecell>
819 </tablerow>
820 <tablerow>
821 <tablecell>
822 <paragraph role="tablecontent" id="par_id3148909" xml-lang="en-US" l10n="U" oldref="159">Date&Time + Number</paragraph>
823 </tablecell>
824 <tablecell>
825 <paragraph role="tablecontent" id="par_id3154806" xml-lang="en-US" l10n="U" oldref="160">Date&Time</paragraph>
826 </tablecell>
827 </tablerow>
828 <tablerow>
829 <tablecell>
830 <paragraph role="tablecontent" id="par_id3151269" xml-lang="en-US" l10n="U" oldref="161">Number + Number</paragraph>
831 </tablecell>
832 <tablecell>
833 <paragraph role="tablecontent" id="par_id3154951" xml-lang="en-US" l10n="U" oldref="162">Number</paragraph>
834 </tablecell>
835 </tablerow>
836 </table>
838 </case>
839 </switch>
840 <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.
841 </caseinline></switchinline></paragraph>
844 <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>
845 </case>
846 </switch>
847 <paragraph role="heading" id="hd_id3155870" xml-lang="en-US" level="3" l10n="U" oldref="61">Time Formats</paragraph>
848 <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>
850 <tablerow>
851 <tablecell>
852 <paragraph role="tablehead" id="par_id3149158" xml-lang="en-US" l10n="U" oldref="63">Format</paragraph>
853 </tablecell>
854 <tablecell>
855 <paragraph role="tablehead" id="par_id3154341" xml-lang="en-US" l10n="U" oldref="64">Format Code</paragraph>
856 </tablecell>
857 </tablerow>
858 <tablerow>
859 <tablecell>
860 <paragraph role="tablecontent" id="par_id3154557" xml-lang="en-US" l10n="U" oldref="65">Hours as 0-23</paragraph>
861 </tablecell>
862 <tablecell>
864 </tablecell>
865 </tablerow>
866 <tablerow>
867 <tablecell>
868 <paragraph role="tablecontent" id="par_id3143218" xml-lang="en-US" l10n="U" oldref="67">Hours as 00-23</paragraph>
869 </tablecell>
870 <tablecell>
872 </tablecell>
873 </tablerow>
874 <tablerow>
875 <tablecell>
876 <paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U" oldref="69">Minutes as 0-59</paragraph>
877 </tablecell>
878 <tablecell>
880 </tablecell>
881 </tablerow>
882 <tablerow>
883 <tablecell>
884 <paragraph role="tablecontent" id="par_id3150531" xml-lang="en-US" l10n="U" oldref="71">Minutes as 00-59</paragraph>
885 </tablecell>
886 <tablecell>
888 </tablecell>
889 </tablerow>
890 <tablerow>
891 <tablecell>
892 <paragraph role="tablecontent" id="par_id3154854" xml-lang="en-US" l10n="U" oldref="73">Seconds as 0-59</paragraph>
893 </tablecell>
894 <tablecell>
896 </tablecell>
897 </tablerow>
898 <tablerow>
899 <tablecell>
900 <paragraph role="tablecontent" id="par_id3149506" xml-lang="en-US" l10n="U" oldref="75">Seconds as 00-59</paragraph>
901 </tablecell>
902 <tablecell>
904 </tablecell>
905 </tablerow>
906 </table>
908 <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>
909 <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>
910 <paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2" l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph>
911 <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>
912 <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>
913 <paragraph role="example" id="par_id3152546" xml-lang="en-US" l10n="U" oldref="172">[NatNum1][$-411]0</paragraph>
914 <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>
915 <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>
916 <paragraph role="heading" id="par_id3153111" xml-lang="en-US" level="3" l10n="CHG" oldref="174">[NatNum1] Transliterations</paragraph>
918 <tablerow>
919 <tablecell>
920 <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>
921 </tablecell>
922 </tablerow>
923 <tablerow>
924 <tablecell>
925 <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>
926 </tablecell>
927 </tablerow>
928 <tablerow>
929 <tablecell>
930 <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>
931 </tablecell>
932 </tablerow>
933 <tablerow>
934 <tablecell>
935 <paragraph role="paragraph" id="par_id3149945" xml-lang="en-US" l10n="U" oldref="178">Thai: Thai characters</paragraph>
936 </tablecell>
937 </tablerow>
938 <tablerow>
939 <tablecell>
940 <paragraph role="paragraph" id="par_id3153264" xml-lang="en-US" l10n="U" oldref="179">Arabic: Indic characters</paragraph>
941 </tablecell>
942 </tablerow>
943 <tablerow>
944 <tablecell>
945 <paragraph role="paragraph" id="par_id3148973" xml-lang="en-US" l10n="U" oldref="180">Indic: Indic characters</paragraph>
946 </tablecell>
947 </tablerow>
948 <tablerow>
949 <tablecell>
950 <paragraph role="paragraph" id="par_idN112A3" xml-lang="en-US" l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew numbering"</comment></paragraph>
951 </tablecell>
952 </tablerow>
953 <tablerow>
954 <tablecell>
955 <paragraph role="paragraph" id="par_id3147520" xml-lang="en-US" l10n="U" oldref="181">[NatNum2] Transliteration in</paragraph>
956 </tablecell>
957 </tablerow>
958 <tablerow>
959 <tablecell>
960 <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>
961 </tablecell>
962 </tablerow>
963 <tablerow>
964 <tablecell>
965 <paragraph role="paragraph" id="par_id3153931" xml-lang="en-US" l10n="U" oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5 [DBNum2]</paragraph>
966 </tablecell>
967 </tablerow>
968 <tablerow>
969 <tablecell>
970 <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>
971 </tablecell>
972 </tablerow>
973 <tablerow>
974 <tablecell>
975 <paragraph role="paragraph" id="par_id3152976" xml-lang="en-US" l10n="U" oldref="185">[NatNum3] Transliteration in</paragraph>
976 </tablecell>
977 </tablerow>
978 <tablerow>
979 <tablecell>
980 <paragraph role="paragraph" id="par_id3154353" xml-lang="en-US" l10n="U" oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph>
981 </tablecell>
982 </tablerow>
983 <tablerow>
984 <tablecell>
985 <paragraph role="paragraph" id="par_id3154669" xml-lang="en-US" l10n="U" oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph>
986 </tablecell>
987 </tablerow>
988 <tablerow>
989 <tablecell>
990 <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>
991 </tablecell>
992 </tablerow>
993 <tablerow>
994 <tablecell>
995 <paragraph role="paragraph" id="par_id3157811" xml-lang="en-US" l10n="U" oldref="189">[NatNum4] Transliteration in</paragraph>
996 </tablecell>
997 </tablerow>
998 <tablerow>
999 <tablecell>
1000 <paragraph role="paragraph" id="par_id3154592" xml-lang="en-US" l10n="U" oldref="190">Chinese: lower case text [DBNum1]</paragraph>
1001 </tablecell>
1002 </tablerow>
1003 <tablerow>
1004 <tablecell>
1005 <paragraph role="paragraph" id="par_id3150350" xml-lang="en-US" l10n="U" oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph>
1006 </tablecell>
1007 </tablerow>
1008 <tablerow>
1009 <tablecell>
1010 <paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="192">Korean: formal lower case text</paragraph>
1011 </tablecell>
1012 </tablerow>
1013 <tablerow>
1014 <tablecell>
1015 <paragraph role="paragraph" id="par_id3153546" xml-lang="en-US" l10n="U" oldref="193">[NatNum5] Transliteration in</paragraph>
1016 </tablecell>
1017 </tablerow>
1018 <tablerow>
1019 <tablecell>
1020 <paragraph role="paragraph" id="par_id3155612" xml-lang="en-US" l10n="U" oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph>
1021 </tablecell>
1022 </tablerow>
1023 <tablerow>
1024 <tablecell>
1025 <paragraph role="paragraph" id="par_id3155909" xml-lang="en-US" l10n="U" oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph>
1026 </tablecell>
1027 </tablerow>
1028 <tablerow>
1029 <tablecell>
1030 <paragraph role="paragraph" id="par_id3151304" xml-lang="en-US" l10n="U" oldref="196">Korean: formal upper case text</paragraph>
1031 </tablecell>
1032 </tablerow>
1033 <tablerow>
1034 <tablecell>
1035 <paragraph role="paragraph" id="par_id3155075" xml-lang="en-US" l10n="U" oldref="197">[NatNum6] Transliteration in</paragraph>
1036 </tablecell>
1037 </tablerow>
1038 <tablerow>
1039 <tablecell>
1040 <paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U" oldref="198">Chinese: fullwidth text [DBNum3]</paragraph>
1041 </tablecell>
1042 </tablerow>
1043 <tablerow>
1044 <tablecell>
1045 <paragraph role="paragraph" id="par_id3154114" xml-lang="en-US" l10n="U" oldref="199">Japanese: fullwidth text</paragraph>
1046 </tablecell>
1047 </tablerow>
1048 <tablerow>
1049 <tablecell>
1050 <paragraph role="paragraph" id="par_id3155344" xml-lang="en-US" l10n="U" oldref="200">Korean: fullwidth text</paragraph>
1051 </tablecell>
1052 </tablerow>
1053 <tablerow>
1054 <tablecell>
1055 <paragraph role="paragraph" id="par_id3155538" xml-lang="en-US" l10n="U" oldref="201">[NatNum7] Transliteration in</paragraph>
1056 </tablecell>
1057 </tablerow>
1058 <tablerow>
1059 <tablecell>
1060 <paragraph role="paragraph" id="par_id3145123" xml-lang="en-US" l10n="U" oldref="202">Japanese: modern short Kanji text</paragraph>
1061 </tablecell>
1062 </tablerow>
1063 <tablerow>
1064 <tablecell>
1065 <paragraph role="paragraph" id="par_id3149424" xml-lang="en-US" l10n="U" oldref="203">Korean: informal lower case text</paragraph>
1066 </tablecell>
1067 </tablerow>
1068 <tablerow>
1069 <tablecell>
1070 <paragraph role="paragraph" id="par_id3153688" xml-lang="en-US" l10n="U" oldref="204">[NatNum8] Transliteration in</paragraph>
1071 </tablecell>
1072 </tablerow>
1073 <tablerow>
1074 <tablecell>
1075 <paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="U" oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph>
1076 </tablecell>
1077 </tablerow>
1078 <tablerow>
1079 <tablecell>
1080 <paragraph role="paragraph" id="par_id3145602" xml-lang="en-US" l10n="U" oldref="206">Korean: informal upper case text</paragraph>
1081 </tablecell>
1082 </tablerow>
1083 <tablerow>
1084 <tablecell>
1085 <paragraph role="paragraph" id="par_id3159228" xml-lang="en-US" l10n="U" oldref="207">[NatNum9] Transliteration in</paragraph>
1086 </tablecell>
1087 </tablerow>
1088 <tablerow>
1089 <tablecell>
1090 <paragraph role="paragraph" id="par_id3154644" xml-lang="en-US" l10n="U" oldref="208">Korean: Hangul characters</paragraph>
1091 </tablecell>
1092 </tablerow>
1093 <tablerow>
1094 <tablecell>
1095 <paragraph role="paragraph" id="par_id3155396" xml-lang="en-US" l10n="U" oldref="209">[NatNum10] Transliteration in</paragraph>
1096 </tablecell>
1097 </tablerow>
1098 <tablerow>
1099 <tablecell>
1100 <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>
1101 </tablecell>
1102 </tablerow>
1103 <tablerow>
1104 <tablecell>
1105 <paragraph role="paragraph" id="par_id3149384" xml-lang="en-US" l10n="U" oldref="211">[NatNum11] Transliteration in</paragraph>
1106 </tablecell>
1107 </tablerow>
1108 <tablerow>
1109 <tablecell>
1110 <paragraph role="paragraph" id="par_id3154213" xml-lang="en-US" l10n="U" oldref="212">Korean: informal Hangul text</paragraph>
1111 </tablecell>
1112 </tablerow>
1113 </table>
1115 </body>
1116 </helpdocument>