Microsoft KB Archive/59747

{|
 * width="100%"|

Excel Number Format that Displays Text Only

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

-

SUMMARY
If you want an Microsoft Excel cell to display only cell data if it is text, format the cell with the &quot;;;&quot; number format (without the quotation marks).

This number format tells Microsoft Excel to display a blank if the number is positive, negative, or zero. It does not affect text display.

Additional query words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.0 4.0 semi-colon semi colon semicolon

Keywords :

Version :

Platform :

Issue type :

Technology :