XL98: Number Sample May Display Number Signs (183532)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q183532 SYMPTOMS
The sample number that appears in the Format Cells dialog box may display
20 number signs (#) instead of an example of the selected number format.
CAUSE
This behavior occurs if the selected cell contains more than 255
characters.
STATUS
This behavior is by design of Microsoft Excel 98.
MORE INFORMATION
Several of the number formats also display number signs when the selected
cell contains more than 255 characters. For example, number signs may
appear when you use decimal numbers or text formats. When you reduce the
total number of characters to less than 255 (after formatting), Microsoft
Excel correctly displays the numbers.
REFERENCES
For more information about the ##### error, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel 98 Help, type the following text
and then click Show Topics. Select the "###### error" topic, and
click Go To. If you are unable to find the information you need, ask the
Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB183532 |
|---|
|