;;; number format fails to hide cell contents in Excel for Mac
This article has been archived. It is offered "as is" and will no longer be updated.
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; theconditional 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 cellare hidden, unless the contents exceed 1,024 characters in length.
XL98 general XL2001 XLX XL2004
Article ID: 178866 - Last Review: 01/11/2015 17:26:34 - Revision: 4.0
- Microsoft Excel 98 for Macintosh
- Microsoft Excel 2001 for Mac
- Microsoft Excel X for Mac
- Microsoft Excel 2004 for Mac
- kbnosurvey kbarchive kbbug kbpending KB178866