View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rhonda Rhonda is offline
external usenet poster
 
Posts: 64
Default Display negative results

I can't seem to get a negative result to display proper, see scenario below:

Cell AL11 is the final calculation of (H11 & I11) - (F11 & G11). Notice the
### marks in AL11 due to the negative results. I need to keep the existing
formula, but somehow display the negative results.

HELP - Rhonda!