if your data is in cell A1, try

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))


"DR_LR_N_SC" wrote:

I am using Excel 2003 and I am trying to simply add numbers in a cell.
for example cell A1 is 57, I want B1 to be 12 (5+7) and so on. I realize
this means adding the hundreds place, tens, place and ones place, I would
like to be able to modify the formula to let me add at least a 6 digit
number. is there a formula for doing this.