Re: summing numbers with in a cell


in cell a1 i have 4099227911503, i know that if i add these numbers up,
the sum would be 52. how do i write a formula that will do the same
thing. i need to add the numbers with in the cell so that i can do a
mod 10 to get the check digit. i am creating a data base for merging
with envelopes and i need to put the planet code "a1" with a check
digit


--
the-charles
------------------------------------------------------------------------
the-charles's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24966
View this thread: http://www.excelforum.com/showthread.php?threadid=384945

.