long numbers colapse

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Windy - 15 May 2008 19:25 GMT

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.

Reply to this Message

Phil Smith - 15 May 2008 22:20 GMT

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

> 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.

Reply to this Message

Windy - 16 May 2008 18:52 GMT

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?

> 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
[quoted text clipped - 11 lines]
> > spreadsheet as .csv to import and this change in numbers causes duplications
> > in numbers and interferes with the import.

Reply to this Message