View Single Post
  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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