Microsoft KB Archive/265912

= Works 6: Unexpected Behavior Occurs When You Use the Leading Zeros Option in the Format Cells Dialog Box =

Article ID: 265912

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works Suite 2001

-



This article was previously published under Q265912



SYMPTOMS
When you use the &quot;Leading zeros&quot; option in a cell in a Microsoft Works Spreadsheet document, the option may not produce the expected number of leading zeros. Therefore, the data displayed in the cell may be different from what you see in the formula bar.

For example, if you format a cell to contain 5 leading zeros, and you then type 1.2 in the cell, the cell displays the value 00001 instead of 0001.2



CAUSE
This behavior can occur if you use the &quot;Leading zeros&quot; option to preserve a certain number of leading zeros in cells containing decimal values.



RESOLUTION
To work around this behavior, do not use the &quot;Leading zeros&quot; option to preserve leading zeros in decimal values. Instead, use it to preserve leading zeros in whole numbers.



MORE INFORMATION
To use the &quot;Leading zeros&quot; option, click Number on the Format menu, and then click Leading zeros in the Select format type box. For example, to preserve leading zeros in a cell that contains a five-digit postal code, type 5 in the Number of digits box.

Additional query words: w_works

Keywords: kbbug kbpending KB265912

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.