Cell Custom Formatting

D

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
 
R

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
Click to expand...

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
 
Top