Numbers on sheet appearing as 1.12E11

[detriez]

Why does this happen and how can I correct it?

112393000000 appear as 1.12E+11
113000000000 appear as 1.13E+11
113097000000 appear as 1.13E+11

The sheet cell appears as 1.12E+11 but when I click on the cell, it value is 112393000000.

I've tried formatting cells to different formats like these but still didnt fix the issue
General
Number
Text

A workaround is placing an apostrophe ' at the beginning of the cell but is there another way for me to correct or prevent it from happening?

 

[Joe4]

Highlight the column, go to "Text to Columns" (from the Data menu), click Next until you get to Step 3, select "Text" and click Finish.

 

[detriez]

Thanks @Joe4 , that worked.. I appreciate the help
Any idea what causes this to happen?

 

[Joe4]

Yes, Excel automatically displays numbers that large in Scientific Notation like that.
The steps I gave you converts the entry to text.

 

[detriez]

Got it Thank you
This typically happens with phone number values. Usually formatted like this.
+1-708-555-1234

 

[Joe4]

I am not sure how your data is getting into Excel, but if you format everything as Text, you won't have that issue.

 

[detriez]

Perfect.. Thanks

 

[Joe4]

You are welcome.