Cell Custom Formatting
 

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


--
drawlings
------------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626
View this thread: http://www.excelforum.com/showthread...hreadid=567378

Cell Custom Formatting
 

On Wed, 2 Aug 2006 06:53:45 -0400, drawlings
wrote:


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