I am using the formula

=SUMPRODUCT(1*MID(B18,ROW(INDIRECT("1:"&LEN(B18))),1))

to add all the numbers in the number together a single number

In column B I put 1975 in column C I put the above formula and in column D I also put the above formula

I am try to get a 1 digit number out of any number. How I have it set up is working perfect

But there are a few numbers I do not want a 1 digit for I want to keep them at 2 digits

the numbers 11, 22 and 33