How to Get single digit

[callsidd]

Hi,

I have a figure in cell A1 & I wish to have single digit in next cell after summing it up.

Example:

In cell A1, there is a figure 1234, if I add 1+2+3+5 then answer comes 11 then again I add 1+1 then it comes 2.

Is there any formula available that if I enter 1234 in a cell, output may appear 2?


Regards...

 

[Vtikhon]

I think this might help you:
http://support.microsoft.com/kb/214053

 

[callsidd]

Thank you so much

Stay blessed .....

Regards...