Stop Excel From Formatting Numbers With "E+11"?

[olimits7]

Hello,

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 .

How can I stop excel from changing the number to this?

Thank you,

olimits7

 

[Datsmart]

Format the cell as a number and it will show as you want. You must have it formated as General.

 

[SIXTH SENSE]

you can right click on the cell and choose Format cell and change the format from general to number with zero number of decimal places.

 

[SIXTH SENSE]

you can right click on the cell and choose Format cell and change the format from general to number with zero number of decimal places.