Hi

try this

=TEXT(SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$25),1))*
ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10),REPT("0",COUNT(--MID(A2,ROW($1:$25),1))))

I modified the formula which I got from here.

It's an array formula. Confirmed with CTRL + SHIFT + ENTER.