Format that shows Zero

  • Thread starter Thread starter Kent
  • Start date Start date
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Assuming you know the cell range that you're going to work
with, change every cell to zero before you start.
 
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
 
Back
Top