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