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.