Bobb; you'd think MS could come up with a simple DIGITSUM() rather than the way you did it.
I had to use Mid to put digits in a row across columns, then use VALUE to sum the digits etc. A touch of conditional formatting brought up the answers in pale green.
I started with numbers 1,2,3.....in colA, their squares in colB.
Quite fun fiddling with Excel again.
Thanks for your posts.
pinkee; do you know Excel?