Microsoft KB Archive/923616

= Number signs (#) are displayed in a cell instead of text characters in Excel 2003 =

Article ID: 923616

Article Last Modified on 11/14/2006

-

APPLIES TO


 * Microsoft Office Excel 2003

-



SYMPTOMS
In Microsoft Office Excel 2003, number signs (#) are displayed in a cell instead of text characters. This behavior occurs if the following conditions are true:
 * You set the category to Text on the Number tab of the Format Cells dialog box.
 * The cell contains between 256 and 1024 text characters.

Note If the cell contains more than 1024 text characters, all the text characters are displayed.



WORKAROUND
To work around this issue, set the category to General on the Number tab of the Format Cells dialog box.

Keywords: kbexpertisebeginner kbformat kbtshoot kbprb KB923616

-

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

© Microsoft Corporation. All rights reserved.