no solution, if you are turning the text into a number, thats a limit in excel -

otherwise you would need to split the text across two cells

still not sure what you are trying to do, as its text and why convert to a number ?

I notice that the last digit is a 1 and then a lot of zeros in between
perhaps you could just extract the part with the numbers and use those and then recombine to make a new ID