Format that shows Zero

K

Kent

I need a custom format that shows a Zero (0) if a cell is empty. Anyone who
has an idea?

K
 
N

Norman Harker

Hi Kent!

Formats can't do that.

You can format positives, negatives, zero, and text. But not AFAIK
empty cells.

By formula you might have something like:

=IF(A1="ShowZero",0,"")

The cell with this formula would have a 0 in it if A1 had the text
ShowZero. Otherwise it would appear empty.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
M

Mark

Assuming you know the cell range that you're going to work
with, change every cell to zero before you start.
 
J

JMay

After completing your work say in range A5:D50 - Highlight it or Select it.
Then at the menu, Edit, Goto... Special button.. Click Blanks (on
left-hand side, then OK
The first available blank cell will be active, enter a 0 (zero) in it BUT
before pressing the enter key hold down the Control key AND the Enter key.
This will fill all selected blanks with the 0. While previously blank cells
are still highlighted/selected go to format cells your choice and complete
(numbers, ))..
HTH
 
Top