zeb,
If you only want it displayed as blank, retaining the value in the cell,
format the cell (Format - Cells - Number - Custom):
General;;General
Change the first General to any format code you want for positive numbers
(0.00, etc), and the other General for how you want zero values displayed.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"pherozeb" wrote in message
...
Could someone please tell me how to display negative values calculated
from a
formula as a blank cell in Excel
|