Dashboard

Editing: number_formats1.html

<table x:str border=0 cellpadding=0 cellspacing=0 width=949 style='border-collapse:
 collapse;table-layout:fixed;width:711pt'>
 <col class=xl2221677 width=283 style='mso-width-source:userset;mso-width-alt:
 12074;width:212pt'>
 <col width=348 style='mso-width-source:userset;mso-width-alt:14848;width:261pt'>
 <col width=159 span=2 style='mso-width-source:userset;mso-width-alt:6784;
 width:119pt'>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 colspan=4 class=xl10321677 align=center width=949
  style='height:25.5pt;border-right:.5pt solid black;width:711pt'>Sample Custom
  Number Formats</td>
 </tr>
 <tr height=34 style='height:25.5pt'>
  <td height=34 class=xl2721677 style='height:25.5pt;border-top:none'>Format
  Code</td>
  <td class=xl2821677 style='border-top:none'>Description</td>
  <td class=xl2921677 width=159 style='border-top:none;width:119pt'>Data with
  General Format</td>
  <td class=xl3021677 width=159 style='border-top:none;width:119pt'>Data with
  Custom Number Format</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt' x:str="'00000">00000</td>
  <td class=xl3321677>Always displays 5 digits. Pads with leading</td>
  <td class=xl3421677 x:num>983</td>
  <td class=xl3521677 style='border-left:none' x:num="983">00983</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>zeros if the number contains fewer than 5 digits.</td>
  <td class=xl3821677 x:num>23589</td>
  <td class=xl3921677 style='border-left:none' x:num>23589</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>This custom format is very useful when you</td>
  <td class=xl3821677 x:num>9856</td>
  <td class=xl3921677 style='border-left:none' x:num="9856">09856</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>work with zip codes.</td>
  <td class=xl4221677 x:num>85632</td>
  <td class=xl4321677 style='border-left:none' x:num>85632</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl2421677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl2421677>&nbsp;</td>
  <td class=xl2521677 width=159 style='width:119pt'>&nbsp;</td>
  <td class=xl2521677 width=159 style='width:119pt'>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0;-0;;@</td>
  <td class=xl4421677>Suppresses zeros in cells.</td>
  <td class=xl3421677 style='border-left:none' x:num>98</td>
  <td class=xl4521677 style='border-left:none' x:num>98</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>This format displays positive values (0) and</td>
  <td class=xl3821677 style='border-left:none' x:num>0</td>
  <td class=xl4721677 style='border-left:none' x:num="0">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>negative values (-0), hides zero values, and</td>
  <td class=xl3821677 style='border-left:none' x:num>-9</td>
  <td class=xl4721677 style='border-left:none' x:num>-9</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>displays text (@).</td>
  <td class=xl3821677 style='border-left:none' x:num>0</td>
  <td class=xl4721677 style='border-left:none' x:num="0">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4821677>&nbsp;</td>
  <td class=xl4221677 style='border-left:none'>hello</td>
  <td class=xl4921677 style='border-left:none'>hello</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>;;;@</td>
  <td class=xl4421677>Suppresses numbers in cells.</td>
  <td class=xl3421677 style='border-left:none' x:num>98</td>
  <td class=xl5121677 style='border-left:none' x:num="98">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>This format hides positive, negative, and zero</td>
  <td class=xl3821677 style='border-left:none' x:num>0</td>
  <td class=xl5221677 style='border-left:none' x:num="0">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>values, and displays only text (@).</td>
  <td class=xl3821677 style='border-left:none' x:num>-9</td>
  <td class=xl5221677 style='border-left:none' x:num="-9">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>&nbsp;</td>
  <td class=xl3821677 style='border-left:none' x:num>0</td>
  <td class=xl5221677 style='border-left:none' x:num="0">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4821677>&nbsp;</td>
  <td class=xl4221677 style='border-left:none'>hello</td>
  <td class=xl5321677 style='border-left:none'>hello</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl2321677>&nbsp;</td>
  <td class=xl2321677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>[Black]General</td>
  <td class=xl3321677>Suppresses errors in cells.</td>
  <td class=xl3421677 x:num="0.33333333333333331" x:fmla="=1/3">0.333333333</td>
  <td class=xl5421677 style='border-left:none' x:num="0.33333333333333331"
  x:fmla="=1/3"><font color="#000000" style='mso-ignore:color'>0.333333333</font></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>This format hides or displays positive,</td>
  <td class=xl3821677 x:err="#DIV/0!" x:fmla="=5/0">#DIV/0!</td>
  <td class=xl5521677 style='border-left:none' x:err="#DIV/0!" x:fmla="=5/0">#DIV/0!</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl5621677 style='height:12.75pt'>(the cells are also
  formatted</td>
  <td class=xl3721677>negative, zero, and text values as black</td>
  <td class=xl3821677 x:err="#N/A" x:fmla="=NA()">#N/A</td>
  <td class=xl5521677 style='border-left:none' x:err="#N/A" x:fmla="=NA()">#N/A</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl5621677 style='height:12.75pt'>with a blue font)</td>
  <td class=xl3721677>characters in the General format.</td>
  <td class=xl3821677 x:num="1.6666666666666667" x:fmla="=5/3">1.666666667</td>
  <td class=xl5521677 style='border-left:none' x:num="1.6666666666666667"
  x:fmla="=5/3"><font color="#000000" style='mso-ignore:color'>1.666666667</font></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677> The text is formatted with a blue font</td>
  <td class=xl3821677 x:num x:fmla="=4/8">0.5</td>
  <td class=xl5521677 style='border-left:none' x:num x:fmla="=4/8"><font
  color="#000000" style='mso-ignore:color'>0.5</font></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677 x:str="so that errors do not appear. The other ">so that
  errors do not appear. The other </td>
  <td class=xl3821677>&nbsp;</td>
  <td class=xl5721677 style='border-left:none'>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>values appear because the number format</td>
  <td class=xl3821677>&nbsp;</td>
  <td class=xl5721677 style='border-left:none'>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>color overrides the font color for the cell.</td>
  <td class=xl4221677>&nbsp;</td>
  <td class=xl5821677 style='border-left:none'>&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl2321677>&nbsp;</td>
  <td class=xl2321677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>#.???</td>
  <td class=xl3321677>Lines numbers up with the decimal.</td>
  <td class=xl3421677 x:num="3.2559999999999998">3.256</td>
  <td class=xl5921677 style='border-left:none' x:num="3.2559999999999998">3.256</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The ? code leaves a space for</td>
  <td class=xl3821677 x:num>5.2</td>
  <td class=xl6021677 style='border-left:none' x:num="5.2">5.2<span
  style="mso-spacerun: yes">� </span></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>insignificant zeros but does not</td>
  <td class=xl3821677 x:num="9.6519999999999992">9.652</td>
  <td class=xl6021677 style='border-left:none' x:num="9.6519999999999992">9.652</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>display them.</td>
  <td class=xl4221677 x:num="98.256799999999998">98.2568</td>
  <td class=xl6121677 style='border-left:none' x:num="98.256799999999998">98.257</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>#,</td>
  <td class=xl3321677>Displays numbers in thousands.</td>
  <td class=xl3421677 x:num>4058.34</td>
  <td class=xl6221677 style='border-left:none' x:num="4058.34">4</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The comma is the thousands</td>
  <td class=xl3821677 x:num>52865</td>
  <td class=xl6321677 style='border-left:none' x:num="52865">53</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>placeholder. If you wish to display</td>
  <td class=xl3821677 x:num>236</td>
  <td class=xl6321677 style='border-left:none' x:num="236">&nbsp;</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>the numbers in millions, use the</td>
  <td class=xl3821677 x:num="5502235623">5502235623</td>
  <td class=xl6321677 style='border-left:none' x:num="5502235623">5502236</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>format #,, instead.</td>
  <td class=xl4221677 x:num>999555</td>
  <td class=xl6421677 style='border-left:none' x:num="999555">1000</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>#,###,, &quot;M&quot;</td>
  <td class=xl3321677>Displays numbers in millions.</td>
  <td class=xl3421677 x:num>32654236</td>
  <td class=xl6521677 style='border-left:none' x:num="32654236">33 M</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The comma is the thousands</td>
  <td class=xl3821677 x:num="4563258963">4563258963</td>
  <td class=xl6621677 style='border-left:none' x:num="4563258963">4,563 M</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>placeholder. The letter &quot;M&quot; is displayed</td>
  <td class=xl3821677 x:num="1235698516311">1.2357E+12</td>
  <td class=xl6621677 style='border-left:none' x:num="1235698516311">1,235,699
  M</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>after each number.</td>
  <td class=xl3821677 x:num>22333666</td>
  <td class=xl6621677 style='border-left:none' x:num="22333666">22 M</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>&nbsp;</td>
  <td class=xl4221677 x:num>12345678</td>
  <td class=xl6721677 style='border-left:none' x:num="12345678">12 M</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0.00,,</td>
  <td class=xl3321677>Represents numbers in millions.</td>
  <td class=xl3421677 x:num>1000000</td>
  <td class=xl6821677 style='border-left:none' x:num="1000000">1.00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>This number format displays numbers</td>
  <td class=xl3821677 x:num="12000000">12000000</td>
  <td class=xl6921677 style='border-left:none' x:num="12000000">12.00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>so that 1 represents one million.</td>
  <td class=xl3821677 x:num="12200000">12200000</td>
  <td class=xl6921677 style='border-left:none' x:num="12200000">12.20</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>&nbsp;</td>
  <td class=xl4221677 x:num>120000</td>
  <td class=xl7021677 style='border-left:none' x:num="120000">0.12</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0;[Red]&quot;Error!&quot;;0;[Red]&quot;Error!&quot;</td>
  <td class=xl3321677>Displays &quot;Error!&quot; in red for negative numbers</td>
  <td class=xl3421677 x:num>10</td>
  <td class=xl7121677 style='border-left:none' x:num>10</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>and text.</td>
  <td class=xl3821677>hello</td>
  <td class=xl7221677 style='border-left:none' x:str="hello">Error!</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>This format may be useful to alert users</td>
  <td class=xl3821677 x:num>-10</td>
  <td class=xl7221677 style='border-left:none' x:num="-10"><font color="#FF0000"
  style='mso-ignore:color'>Error!</font></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>that they entered invalid text in a cell.</td>
  <td class=xl4221677 x:num>0</td>
  <td class=xl7321677 style='border-left:none' x:num>0</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0.0�</td>
  <td class=xl3321677>Displays numbers with the degree symbol.</td>
  <td class=xl3421677 x:num>32.63</td>
  <td class=xl7421677 style='border-left:none' x:num="32.63">32.6�</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The degree symbol uses the character</td>
  <td class=xl3821677 x:num="63.258000000000003">63.258</td>
  <td class=xl7521677 style='border-left:none' x:num="63.258000000000003">63.3�</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>map code ALT+0176.</td>
  <td class=xl3821677 x:num>96.75</td>
  <td class=xl7521677 style='border-left:none' x:num="96.75">96.8�</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>&nbsp;</td>
  <td class=xl4221677 x:num>-5.36</td>
  <td class=xl7621677 style='border-left:none' x:num="-5.36">-5.4�</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0.00 �</td>
  <td class=xl3321677>Displays numbers with the British pounds</td>
  <td class=xl3421677 x:num>100</td>
  <td class=xl7721677 style='border-left:none' x:num="100">100.00 �</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>symbol.</td>
  <td class=xl3821677 x:num>67.63</td>
  <td class=xl7821677 style='border-left:none' x:num="67.63">67.63 �</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The pound symbol uses the character</td>
  <td class=xl3821677 x:num>0</td>
  <td class=xl7821677 style='border-left:none' x:num="0">0.00 �</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>map code ALT+0163.</td>
  <td class=xl4221677 x:num>9.63</td>
  <td class=xl7921677 style='border-left:none' x:num="9.63">9.63 �</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0.0_-;0.0-</td>
  <td class=xl3321677>Displays the negative sign on the right side</td>
  <td class=xl3421677 x:num>-5</td>
  <td class=xl8021677 style='border-left:none' x:num="-5">5.0-</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>of the number.</td>
  <td class=xl3821677 x:num>-40.3</td>
  <td class=xl8121677 style='border-left:none' x:num="-40.3">40.3-</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>This format also pads space at the right</td>
  <td class=xl3821677 x:num>50</td>
  <td class=xl8121677 style='border-left:none' x:num="50">50.0 </td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>of a postive number so that the decimals line up.</td>
  <td class=xl4221677 x:num>-10.99</td>
  <td class=xl8221677 style='border-left:none' x:num="-10.99">11.0-</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'><span
  style="mso-spacerun: yes">���� </span>@</td>
  <td class=xl3321677>Displays 5 spaces and then the text to</td>
  <td class=xl8321677>this</td>
  <td class=xl8421677 style='border-left:none' x:str="this"><span
  style="mso-spacerun: yes">���� </span>this</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl5621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>give the appearance of a tab (or indent).</td>
  <td class=xl8521677>is</td>
  <td class=xl8621677 style='border-left:none' x:str="is"><span
  style="mso-spacerun: yes">���� </span>is</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl5621677 style='height:12.75pt'>(5 spaces, then @)</td>
  <td class=xl3721677>&nbsp;</td>
  <td class=xl8521677>a</td>
  <td class=xl8621677 style='border-left:none' x:str="a"><span
  style="mso-spacerun: yes">���� </span>a</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>&nbsp;</td>
  <td class=xl8721677>test</td>
  <td class=xl8821677 style='border-left:none' x:str="test"><span
  style="mso-spacerun: yes">���� </span>test</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt' x:str="'@*-">@*-</td>
  <td class=xl3321677>Shows text leaders.</td>
  <td class=xl8321677>Apples</td>
  <td class=xl8921677 style='border-left:none' x:str="Apples">Apples
  ---------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>In a number format, the asterisk (*)</td>
  <td class=xl8521677>Oranges</td>
  <td class=xl9021677 style='border-left:none' x:str="Oranges">Oranges
  -------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>causes Microsoft Excel to repeat the next</td>
  <td class=xl8521677>Bananas</td>
  <td class=xl9021677 style='border-left:none' x:str="Bananas">Bananas
  ------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>character until the width of the column</td>
  <td class=xl8521677>Pears</td>
  <td class=xl9021677 style='border-left:none' x:str="Pears">Pears
  -----------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>is filled. Text leaders are commonly used in</td>
  <td class=xl8521677>Peaches</td>
  <td class=xl9021677 style='border-left:none' x:str="Peaches">Peaches
  ------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>tables of contents.</td>
  <td class=xl8521677>Plums</td>
  <td class=xl9021677 style='border-left:none' x:str="Plums">Plums
  ----------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>&nbsp;</td>
  <td class=xl8721677>Grapes</td>
  <td class=xl9121677 style='border-left:none' x:str="Grapes">Grapes
  ---------------------------</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
  <td class=xl5021677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0 &quot;dollars and&quot;
  .00 &quot;cents&quot;</td>
  <td class=xl4421677>Displays a currency value with words.</td>
  <td class=xl3421677 style='border-left:none' x:num>20.36</td>
  <td class=xl9221677 style='border-left:none' x:num="20.36">20 dollars and .36
  cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>This format displays the whole number</td>
  <td class=xl3821677 style='border-left:none' x:num>2.55</td>
  <td class=xl9321677 style='border-left:none' x:num="2.55">2 dollars and .55
  cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>portion of the number followed by the</td>
  <td class=xl3821677 style='border-left:none' x:num>45.36</td>
  <td class=xl9321677 style='border-left:none' x:num="45.36">45 dollars and .36
  cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677>words &quot;dollars and,&quot; followed by the fractional</td>
  <td class=xl3821677 style='border-left:none' x:num>69</td>
  <td class=xl9321677 style='border-left:none' x:num="69">69 dollars and .00
  cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3621677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4621677 x:str="portion of the number and the word &quot;cents.&quot; ">portion
  of the number and the word &quot;cents.&quot; </td>
  <td class=xl3821677 style='border-left:none' x:num>36.25</td>
  <td class=xl9321677 style='border-left:none' x:num="36.25">36 dollars and .25
  cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl4021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4821677>&nbsp;</td>
  <td class=xl4221677 style='border-left:none' x:num>1003.33</td>
  <td class=xl9421677 style='border-left:none' x:num="1003.33">1003 dollars and
  .33 cents</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl3121677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
  <td class=xl3221677>&nbsp;</td>
 </tr>
 <tr height=18 style='height:13.5pt'>
  <td height=18 class=xl2621677 style='height:13.5pt'>0&quot;.&quot;00</td>
  <td class=xl3321677>Displays a value in hundreds.</td>
  <td class=xl9521677 align=right x:num>2300</td>
  <td class=xl9621677 align=right style='border-left:none' x:num="2300">23.00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl9721677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>The comma is used only for scaling</td>
  <td class=xl9821677 align=right x:num>23</td>
  <td class=xl9921677 align=right style='border-left:none' x:num="23">0.23</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl9721677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677 x:str="numbers in multiples of one thousand. Use ">numbers
  in multiples of one thousand. Use </td>
  <td class=xl9821677 align=right x:num>400</td>
  <td class=xl9921677 align=right style='border-left:none' x:num="400">4.00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl9721677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677>a number format with a decimal character</td>
  <td class=xl9821677 align=right x:num>5000</td>
  <td class=xl9921677 align=right style='border-left:none' x:num="5000">50.00</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl9721677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl3721677 x:str="between the placeholders to display a  ">between
  the placeholders to display a<span style="mso-spacerun: yes">� </span></td>
  <td class=xl9821677 align=right x:num>-90</td>
  <td class=xl9921677 align=right style='border-left:none' x:num="-90">-0.90</td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl10021677 style='height:12.75pt'>&nbsp;</td>
  <td class=xl4121677>number as a multiple of 100 or 10 (0&quot;.&quot;0).</td>
  <td class=xl10121677 align=right x:num>0</td>
  <td class=xl10221677 align=right style='border-left:none' x:num>0.00</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=283 style='width:212pt'></td>
  <td width=348 style='width:261pt'></td>
  <td width=159 style='width:119pt'></td>
  <td width=159 style='width:119pt'></td>
 </tr>
 <![endif]>
</table>

</div>
<br>

</body>

</html>

Cancel

Dashboard

Log In

Powered by WordPress