I already tried SUM on range but result is zero. But I was using the MID
function solely, I'll try Chip's code instead, thanks.
--
ChewinFoil --)--------


"Gord Dibben" wrote:

Chip's code returns each digit to a separate cell as a number.

Simply SUM the range.

Or..........if you want to leave all the digits in one cell like 5445655

Use this formula =SUMPRODUCT(--MID($A$1,ROW(INDIRECT("1:" & LEN($A$1))),1))

which returns 34


Gord Dibben MS Excel MVP


On Mon, 8 Dec 2008 12:13:01 -0800, ChewinFoil
wrote:

So now that I understand the MID function is there any way to use the
individually displayed characters as numbers. Since the function is just
displaying the character in that position is there any way to use the actual
value? For example from my original question could the 5 4 4 5 6 5 5 now be
added to equal 34. Thanks.