Dear all,

I turn to you to help me out in something I cannot for the life of me figure out.

Say I have a table full of positive numbers, negative numbers, and zeros.

So basically what I usually do is format the table by selecting all the numbers and doing a Ctrl+Shift+1 which basically turns all the numbers to two decimal places and with the comma separation for the thousands, millions, and stuff like that.

So now I would like to hide the zeros using the Format Cell Custom command. I read that the following custom format would hide all the zeros: 0;-0;;@

However, that will override the two decimal number format and the comma separation for thousands, millions, etc.

How could I combine the two? Basically, hiding the zero values, and preserving the number format I just described?

Thanks!



DT