Cell Custom Formatting

[drawlings]

Hi I use a custom format for all number cells

##,##0.00 ;[Red](##,##0.00);-

This format will display a '-' if the value is '0', but I also need t
display a '-' if the cell is blank. Any ideas how this could be done

Thank

 

[Ron Rosenfeld]

Hi I use a custom format for all number cells

##,##0.00 ;[Red](##,##0.00);-

This format will display a '-' if the value is '0', but I also need to
display a '-' if the cell is blank. Any ideas how this could be done

Thanks

I do not believe that possible with formatting.

How does data get into the cell?

If it is entered directly, then perhaps a VBA routine triggered by opening the
worksheet, to write 0's into the range.

If the data is a result of a formula, then "wrapping" the formula in an IF
statement, perhaps something like:

=IF(ISNUMBER(your_formula),your_formula,0)


--ron