4th Floor, 4 Tabernacle Street London EC2A 4LU

Hiding zero’s in Excel

hide zero values in selected cells

Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

  1. Select the cells that contain the zero (0) values that you want to hide.
  1. On the Home tab, in the Cells group, click Format, and then click Format Cells.
  1. In the Category list, click Custom.
  2. In the Type box, type 0;-0;;@

4. For %percentages – type 0%;-0%;;@