Possibley those numbers are actually rext.

Format them as General then copy an empty cell.

Select the cells with "numbers" and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Sat, 10 Nov 2007 11:18:02 -0800, loveforlife
wrote:

I enter =SUM(C11+C21) C11 is 10000 and C21 is (9000)
My formula result is 0. What gives?