Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
;;; number format fails to hide cell contents in Excel for Mac
Article ID: 178866 - View products that this article applies to.
This article was previously published under Q178866
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:
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: