Number Formatting


Steve Haack

I have a strange scenario. I have 2 different worksheets in my workbook. I
have similiar data and formulas in both (in fact I created the second one as
a copy/paste of the first one).

On my first sheet, I have some cells with a sum formula, and I have the cell
formatted as "General" and when the result is zero, it does not display
anything in the cell.

On the other sheet, it has the same formula and number formatting, but it
displays the zeros.

When I got into the number formatting for each cell, the one that displays
nothing for zero, shows that in the "Sameple" in the number formatting dialog
and the other shows the zero in the dialog.

I would like to have the behavior of showing nothing for zero. Does anyone
know how I actually got that to happen?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question