Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Number signs (#) are displayed in a cell instead of text characters in Excel 2003

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

View products that this article applies to.

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.

↑ Back to the top

Workaround

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

↑ Back to the top

Keywords: KB923616, kbprb, kbtshoot, kbformat, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 923616
Revision : 1
Created on : 11/14/2006
Published on : 11/14/2006
Exists online : False
Views : 208