Rhonda
To add to Pete's response, #### usually means that the cell has a number
that is too large to fit into the cell. That is, the column is not wide
enough to hold that number. Increase the width of the cell as needed. HTH
Otto
"Rhonda" wrote in message
...
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!