How to format that cell display only one digit of a number at a time?

[soniachong]

For example, I put the 1 9 (two columns) and did a sum on it and I want it to calculate 10 in two separate column like so:-

1 9 = 1 0 = 1
or
6 7 = 1 3 = 4


I know summing it will give it 10 or 13 but I want to further reduced the number so I need it to display only 1 digit per column.

Help?

Thanks
Sonia

 

[Misca]

Try: =SUM(LEFT(SUM(A2:B2)*0.1),RIGHT(SUM(A2:B2),1))

 

[Ruddles]

If you just want the final single digit, use:-

=MOD(A1+B1,9)

(assuming your numbers are in A1 and B1)