K
Kent
I need a custom format that shows a Zero (0) if a cell is empty. Anyone who
has an idea?
K
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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.
M
Mark
Assuming you know the cell range that you're going to work
with, change every cell to zero before you start.
with, change every cell to zero before you start.
J
JMay
After completing your work say in range A5
50 - 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
50 - 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