Removing zero values from cells
in Microsoft Excel
To play this video you must have installed the free
Adobe
Flash Player, please click the link to install it if the video
below doesn't run.
Formula used in demonstration
|
-
=VLOOKUP(A2,patient!A:N,4,FALSE)
-
Format Cells using Custom category = 0;-0;;@
-
or use = 0;-0;
|
Alternative way to display or hide all zero values on a worksheet
-
On the Tools menu, click Options, and then click the View tab.
-
Do one of the following:
-
To display zero (0) values in cells, select the Zero values
check box.
-
To display zero values as blank cells, clear the check box
|
|
