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="textscalcguideformat_value_userdefxml" indexer="include" status="PUBLISH"> 36 <title xml-lang="en-US" id="tit">User-defined Number Formats</title> 37 <filename>/text/scalc/guide/format_value_userdef.xhp</filename> 38 </topic> 39 </meta> 40 <body> 41<bookmark xml-lang="en-US" branch="index" id="bm_id3143268"><bookmark_value>numbers;user-defined formatting</bookmark_value> 42 <bookmark_value>formatting; user-defined numbers</bookmark_value> 43 <bookmark_value>number formats; millions</bookmark_value> 44 <bookmark_value>format codes; user-defined number formats</bookmark_value> 45</bookmark><comment>mw changed "numbers;"</comment> 46<paragraph xml-lang="en-US" id="hd_id3143268" role="heading" level="1" l10n="U" 47 oldref="26"><variable id="format_value_userdef"><link href="text/scalc/guide/format_value_userdef.xhp" name="User-defined Number Formats">User-defined Number Formats</link> 48</variable></paragraph> 49 <paragraph xml-lang="en-US" id="par_id3150400" role="paragraph" l10n="U" oldref="1">You can define your own number formats to display numbers in <item type="productname">%PRODUCTNAME</item> Calc.</paragraph> 50 <paragraph xml-lang="en-US" id="par_id3150767" role="paragraph" l10n="U" oldref="2">As an example, to display the number 10,200,000 as 10.2 Million:</paragraph> 51 <list type="ordered"> 52 <listitem> 53 <paragraph xml-lang="en-US" id="par_id3150868" role="listitem" l10n="U" oldref="3">Select the cells to which you want to apply a new, user-defined format.</paragraph> 54 </listitem> 55 <listitem> 56 <paragraph xml-lang="en-US" id="par_id3149664" role="listitem" l10n="U" oldref="4">Choose <emph>Format - Cells - Numbers</emph>.</paragraph> 57 </listitem> 58 <listitem> 59 <paragraph xml-lang="en-US" id="par_id3149260" role="listitem" l10n="U" oldref="5">In the <emph>Categories</emph> list box select "User-defined".</paragraph> 60 </listitem> 61 <listitem> 62 <paragraph xml-lang="en-US" id="par_id3148646" role="listitem" l10n="U" oldref="6">In the <emph>Format code</emph> text box enter the following code:</paragraph> 63 <paragraph xml-lang="en-US" id="par_id3152596" role="code" l10n="U" oldref="7">0.0,, "Million"</paragraph> 64 </listitem> 65 <listitem> 66 <paragraph xml-lang="en-US" id="par_id3144764" role="listitem" l10n="U" oldref="8">Click OK.</paragraph> 67 </listitem> 68 </list> 69 <paragraph xml-lang="en-US" id="par_id3155417" role="paragraph" l10n="U" oldref="9">The following table shows the effects of rounding, thousands delimiters (,), decimal delimiters (.) and the placeholders # and 0.</paragraph> 70 <table id="tbl_id3153157"> 71 <tablerow> 72 <tablecell> 73 <paragraph xml-lang="en-US" id="par_id3146971" role="tablehead" l10n="U" oldref="10">Number</paragraph> 74 </tablecell> 75 <tablecell> 76 <paragraph xml-lang="en-US" id="par_id3154757" role="tablehead" l10n="U" oldref="11">.#,, "Million"</paragraph> 77 </tablecell> 78 <tablecell> 79 <paragraph xml-lang="en-US" id="par_id3147338" role="tablehead" l10n="U" oldref="12">0.0,, "Million"</paragraph> 80 </tablecell> 81 <tablecell> 82 <paragraph xml-lang="en-US" id="par_id3146920" role="tablehead" l10n="U" oldref="13">#,, "Million"</paragraph> 83 </tablecell> 84 </tablerow> 85 <tablerow> 86 <tablecell> 87 <paragraph xml-lang="en-US" id="par_id3147344" role="paragraph" l10n="U" oldref="14">10200000</paragraph> 88 </tablecell> 89 <tablecell> 90 <paragraph xml-lang="en-US" id="par_id3147003" role="paragraph" l10n="U" oldref="15">10.2 Million</paragraph> 91 </tablecell> 92 <tablecell> 93 <paragraph xml-lang="en-US" id="par_id3166426" role="paragraph" l10n="U" oldref="16">10.2 Million</paragraph> 94 </tablecell> 95 <tablecell> 96 <paragraph xml-lang="en-US" id="par_id3155113" role="paragraph" l10n="U" oldref="17">10 Million</paragraph> 97 </tablecell> 98 </tablerow> 99 <tablerow> 100 <tablecell> 101 <paragraph xml-lang="en-US" id="par_id3150369" role="paragraph" l10n="U" oldref="18">500000</paragraph> 102 </tablecell> 103 <tablecell> 104 <paragraph xml-lang="en-US" id="par_id3145585" role="paragraph" l10n="U" oldref="19">.5 Million</paragraph> 105 </tablecell> 106 <tablecell> 107 <paragraph xml-lang="en-US" id="par_id3154486" role="paragraph" l10n="U" oldref="20">0.5 Million</paragraph> 108 </tablecell> 109 <tablecell> 110 <paragraph xml-lang="en-US" id="par_id3146114" role="paragraph" l10n="U" oldref="21">1 Million</paragraph> 111 </tablecell> 112 </tablerow> 113 <tablerow> 114 <tablecell> 115 <paragraph xml-lang="en-US" id="par_id3155810" role="paragraph" l10n="U" oldref="22">100000000</paragraph> 116 </tablecell> 117 <tablecell> 118 <paragraph xml-lang="en-US" id="par_id3153818" role="paragraph" l10n="U" oldref="23">100. Million</paragraph> 119 </tablecell> 120 <tablecell> 121 <paragraph xml-lang="en-US" id="par_id3151241" role="paragraph" l10n="U" oldref="24">100.0 Million</paragraph> 122 </tablecell> 123 <tablecell> 124 <paragraph xml-lang="en-US" id="par_id3144771" role="paragraph" l10n="U" oldref="25">100 Million</paragraph> 125 </tablecell> 126 </tablerow> 127 </table> 128 129 <section id="relatedtopics"> 130 <embed href="text/scalc/guide/format_value.xhp#format_value"/> 131 <embed href="text/scalc/guide/currency_format.xhp#currency_format"/> 132 <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> 133 <embed href="text/shared/01/05020301.xhp#zahlenformatcodes"/> 134 </section> 135 </body> 136</helpdocument>