I have a simple formula subtracting one cell from another using =SUM(XX,
-XX). When I click on fx and bring up the function arguments box, the
formula result is displayed correctly in that box. However, the cell
containing the formula will only display a zero. I have tried reformatting
the cells to no avail. I have also tried getting a result using =XX-XX and
that does not work either.