XL97: ;;; Number Format Fails to Hide Cell Contents
ID: Q158879
|
The information in this article applies to:
-
Microsoft Excel 97 for Windows
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.
- In the Condition box, 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. Click the Font tab. Then, in the Color box, click
white (or the color of the cell's 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 cell(s) you want to format.
- On the Format menu, click Cells. Then, click the Number tab.
- In the Category list, click 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:
XL97 general
Keywords : xlformat
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug
|