summaryrefslogtreecommitdiff
path: root/helpcontent2
diff options
context:
space:
mode:
authorKurt Zenker <kz@openoffice.org>2008-03-07 11:14:34 +0000
committerKurt Zenker <kz@openoffice.org>2008-03-07 11:14:34 +0000
commit2bc12ae0544a5b624062090ffd8985e0a38caba7 (patch)
tree8a033834680bf18b6d4af46138dc3cc26f439e11 /helpcontent2
parent5057fc2ca5cdc87cfef1ffa0f459c7fba6122a19 (diff)
INTEGRATION: CWS hcshared17_DEV300 (1.4.280); FILE MERGED
2008/02/22 09:23:21 ufi 1.4.280.1: vor resync
Diffstat (limited to 'helpcontent2')
-rwxr-xr-xhelpcontent2/source/text/scalc/guide/format_value_userdef.xhp209
1 files changed, 108 insertions, 101 deletions
diff --git a/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp b/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp
index 35f426d6b3..50840a52d0 100755
--- a/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp
+++ b/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp
@@ -1,13 +1,15 @@
<?xml version="1.0" encoding="UTF-8"?>
-<!--***********************************************************************
+
+<!--
+ ***********************************************************************
*
* OpenOffice.org - a multi-platform office productivity suite
*
- * $RCSfile: format_value_userdef.xhp,v $
+ * $RCSfile: format_value_userdef.xhp,v $fileonly,v $
*
- * $Revision: 1.4 $
+ * $Revision: 1.5 $
*
- * last change: $Author: rt $ $Date: 2005-09-07 18:37:02 $
+ * last change: $Author: kz $ $Date: 2008-03-07 12:14:34 $
*
* The Contents of this file are made available subject to
* the terms of GNU Lesser General Public License Version 2.1.
@@ -32,112 +34,117 @@
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
- ************************************************************************-->
-
-<helpdocument version="1.0">
+ ************************************************************************
+ -->
+
+
+ <helpdocument version="1.0">
<meta>
<topic id="textscalcguideformat_value_userdefxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">User-defined Number Formats</title>
+<title xml-lang="en-US" id="tit">User-defined Number Formats</title>
<filename>/text/scalc/guide/format_value_userdef.xhp</filename>
</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-09-01T17:48:19">converted from old format - fpe
-dedr: fixed #i30800#</lastedited>
-</history>
</meta>
<body>
+
+
+
<bookmark xml-lang="en-US" branch="index" id="bm_id3143268"><bookmark_value>numbers; user-defined formatting in tables</bookmark_value>
<bookmark_value>formatting; user-defined numbers</bookmark_value>
<bookmark_value>number formats; millions</bookmark_value>
+<bookmark_value>format codes; user-defined number formats</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3143268" xml-lang="en-US" level="1" l10n="U" 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>
+ <comment>mw copied "format codes;" from shared/01/05020300.xhp</comment>
+ <paragraph xml-lang="en-US" id="hd_id3143268" role="heading" level="1" l10n="U" 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>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U" oldref="1">You can define your own number formats to display numbers in <item type="productname">%PRODUCTNAME</item> Calc.</paragraph>
-<paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="2">As an example, to display the number 10,200,000 as 10.2 Million:</paragraph>
-<list type="ordered">
-<listitem>
-<paragraph role="listitem" id="par_id3150868" xml-lang="en-US" l10n="U" oldref="3">Select the cells to which you want to apply a new, user-defined format.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3149664" xml-lang="en-US" l10n="U" oldref="4">Choose <emph>Format - Cells - Numbers</emph>.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="5">In the <emph>Categories</emph> list box select "User-defined".</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3148646" xml-lang="en-US" l10n="U" oldref="6">In the <emph>Format code</emph> text box enter the following code:</paragraph>
-<paragraph role="code" id="par_id3152596" xml-lang="en-US" l10n="U" oldref="7">0.0,, "Million"</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3144764" xml-lang="en-US" l10n="U" oldref="8">Click OK.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id3155417" xml-lang="en-US" l10n="U" oldref="9">The following table shows the effects of rounding, thousands delimiters (,), decimal delimiters (.) and the placeholders # and 0.</paragraph>
-<table id="tbl_id3153157">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3146971" xml-lang="en-US" l10n="U" oldref="10">Number</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3154757" xml-lang="en-US" l10n="U" oldref="11">.#,, "Million"</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3147338" xml-lang="en-US" l10n="U" oldref="12">0.0,, "Million"</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3146920" xml-lang="en-US" l10n="U" oldref="13">#,, "Million"</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147344" xml-lang="en-US" l10n="U" oldref="14">10200000</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147003" xml-lang="en-US" l10n="U" oldref="15">10.2 Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="16">10.2 Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155113" xml-lang="en-US" l10n="U" oldref="17">10 Million</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150369" xml-lang="en-US" l10n="U" oldref="18">500000</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145585" xml-lang="en-US" l10n="U" oldref="19">.5 Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U" oldref="20">0.5 Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3146114" xml-lang="en-US" l10n="U" oldref="21">1 Million</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155810" xml-lang="en-US" l10n="U" oldref="22">100000000</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153818" xml-lang="en-US" l10n="U" oldref="23">100. Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3151241" xml-lang="en-US" l10n="U" oldref="24">100.0 Million</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3144771" xml-lang="en-US" l10n="U" oldref="25">100 Million</paragraph>
-</tablecell>
-</tablerow>
-</table>
-
-<section id="relatedtopics">
-<embed href="text/scalc/guide/format_value.xhp#format_value"/>
-<embed href="text/scalc/guide/currency_format.xhp#currency_format"/>
-<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
-<embed href="text/shared/01/05020301.xhp#zahlenformatcodes"/>
-</section>
-</body>
+ <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>
+ <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>
+ <list type="ordered">
+ <listitem>
+ <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>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id3149664" role="listitem" l10n="U" oldref="4">Choose <emph>Format - Cells - Numbers</emph>.</paragraph>
+ </listitem>
+ <listitem>
+ <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>
+ </listitem>
+ <listitem>
+ <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>
+ <paragraph xml-lang="en-US" id="par_id3152596" role="code" l10n="U" oldref="7">0.0,, "Million"</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph xml-lang="en-US" id="par_id3144764" role="listitem" l10n="U" oldref="8">Click OK.</paragraph>
+ </listitem>
+ </list>
+ <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>
+ <table id="tbl_id3153157">
+
+
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3146971" role="tablehead" l10n="U" oldref="10">Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3154757" role="tablehead" l10n="U" oldref="11">.#,, "Million"</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3147338" role="tablehead" l10n="U" oldref="12">0.0,, "Million"</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3146920" role="tablehead" l10n="U" oldref="13">#,, "Million"</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3147344" role="paragraph" l10n="U" oldref="14">10200000</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3147003" role="paragraph" l10n="U" oldref="15">10.2 Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3166426" role="paragraph" l10n="U" oldref="16">10.2 Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3155113" role="paragraph" l10n="U" oldref="17">10 Million</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3150369" role="paragraph" l10n="U" oldref="18">500000</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3145585" role="paragraph" l10n="U" oldref="19">.5 Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3154486" role="paragraph" l10n="U" oldref="20">0.5 Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3146114" role="paragraph" l10n="U" oldref="21">1 Million</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3155810" role="paragraph" l10n="U" oldref="22">100000000</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3153818" role="paragraph" l10n="U" oldref="23">100. Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3151241" role="paragraph" l10n="U" oldref="24">100.0 Million</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph xml-lang="en-US" id="par_id3144771" role="paragraph" l10n="U" oldref="25">100 Million</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <section id="relatedtopics">
+
+ <embed href="text/scalc/guide/format_value.xhp#format_value"/>
+ <embed href="text/scalc/guide/currency_format.xhp#currency_format"/>
+ <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
+ <embed href="text/shared/01/05020301.xhp#zahlenformatcodes"/>
+
+ </section>
+ </body>
</helpdocument>
generated by cgit (git 2.34.1) at 2025-02-15 19:30:41 +0000