XL98: Number Sample May Display Number Signs

ID: Q183532


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


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.

Additional query words: pound sign XL98

Keywords : kbdta xlformat
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.