Works 6: Unexpected Behavior Occurs When You Use the Leading Zeros Option in the Format Cells Dialog Box (265912)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works Suite 2001
This article was previously published under Q265912 SYMPTOMS
When you use the "Leading zeros" 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 "Leading zeros" option to preserve a certain number of leading zeros in cells containing decimal values.
RESOLUTION
To work around this behavior, do not use the "Leading zeros" option to preserve leading zeros in decimal values. Instead, use it to preserve leading zeros in whole numbers.
MORE INFORMATION
To use the "Leading zeros" 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.
| Modification Type: | Major | Last Reviewed: | 10/7/2003 |
|---|
| Keywords: | kbbug kbpending KB265912 |
|---|
|