Is there any special number formatting in your cell. Try setting it to
General. Right-click cell, select 'Format Cells'. On the Number tab, set
to General.
Any change?

Paul

"Excel User" wrote in message
...
I did try that and it still return a zero value in the actual cell,
although
as before, if I open the function arguments pop up box, the correct value
is
listed there.
Any other ideas why a function result would display correctly in the
arguments box but a completely different number display in the cell
itself?

"via135" wrote:


hi
try
=SUM(XX,(-XX)


-via135


Excel User Wrote:
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.


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=502600