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