long numbers colapse

[Windy]

What causes a long number - 555116311212 - to colapse into 5.55E+11? When I
try to widen the cell the number now reads 555116000000. I am using this
spreadsheet as .csv to import and this change in numbers causes duplications
in numbers and interferes with the import.

 

[Phil Smith]

I am going out on a limb here, and assuming these very large numbers are
not values, but identification numbers of some sort? Not something you
would tend to perform math against?

In that case, you want Excel to treat it as text, rather than a number.

If you have any control of the CSV, output that field as text by putting
quotes around it...

Phil

 

[Windy]

Thank you, but I cannot concatenate using a quote and also even though I am
not using this to perform math with, it needs to be a number to import into
the field correctly. Do you have any other ideas?