[Solved] Minus function not working

[ayman]

This function, '=G15-E15' returns 15800 if G15 is 95000 and E15 is 79200.
however, if i I add one more 0 on the end of G15 to make it 950000, the function returns '###'.

Why is this, and what can I do about it?

all the boxes are on default format, and i have tried then making them general, number, currency, etc... the result is always the same

[RoryOF]

widen the column.

[ayman]

haha i can't believe thats all it was. i have been on this problem for hours!
thank you so much