Select the cells you wish to format in this way, then:
<Format <Cells <Number tab,
Click on "Custom" in the left (Category) window,
In the "Type" box, on the right, enter:
General;

This custom format will hide the display of negative numbers, either keyed
in, or returned from formulas.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cfuller" wrote in message
...
how do I hide the display of negative numbers?