XL98: ;;; Number Format Fails to Hide Cell Contents
ID: Q178866
|
The information in this article applies to:
-
Microsoft Excel 98 Macintosh Edition
SYMPTOMS
When you format a cell with the following number format
;;;
the contents of the cell may still appear.
CAUSE
This problem occurs when the cell contains more than 1,024 characters.
WORKAROUND
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.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
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.
Additional query words:
XL98 general
Keywords : xlformat
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
|