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