When you format a cell with the following number format
the contents of the cell may still appear.
This problem occurs when the cell contains more than 1,024 characters.
To hide the contents of a cell that contains more than 1,024 characters,
follow these steps:
- Select the cell that contains characters you want to hide.
- On the Format menu, click Conditional Formatting.
- Under Condition 1, click Formula Is. Then, in the formula box,
type =ISERROR(VALUE(<address>)) where
<address> is the address of the active cell (for example, A1).
- Click Format. Select the Font tab. Then, in the Color box, select
White (or the color of the cell background), and click OK.
- Click OK.
Note that you still must apply the ;;; number format to the cell; the
conditional formatting only hides the cell contents when the contents
exceed 1,024 characters in length.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
In Microsoft Excel, you can hide the contents of a cell by applying the ;;;
number format to the cell. To do this, follow these steps:
- Select the cells you want to format.
- On the Format menu, click Cells. Then, select the Number tab.
- In the Category list, select Custom. Then, in the Type box, type ;;; and click OK.
When you format a cell with this number format, the characters in the cell
are hidden, unless the contents exceed 1,024 characters in length.
Article ID: 178866 - Last Review: September 18, 2011 - Revision: 3.0
- Microsoft Excel 98 for Macintosh
- Microsoft Excel 2001 for Mac
- Microsoft Excel X for Mac
- Microsoft Excel 2004 for Mac