Solve error "E+11" in Excel by Numbers Formatting

Описание: I have an excel spreadsheet that has product numbers within single quotes, and for one of my programs I have to remove the single quotes. But when I remove the single quotes it changes the number and adds the "E+11" at the end of the number.

For example, I have a number like '742725274284' and when I remove the single quotes it shows this 7.42725E+11