=5+5
is 10
(I can see you're impressed so far)
as Christal mentioned, could it be formatting ?
I formatted 10 as custom : yyyymd and it gave 1900110, which is close
did you actually type 5+5 or were they linked to other cells with maybe rounding applied ?