Import issues for numeric columns

[kevinmcdonald]

Hey all,

I am importing a spreadsheet that has three numeric columns, and all three are importing differently. The first column (12 digits) is importing correctly as a simple string of numbers - which is how all three columns are formatted in the spreadsheet. The second (10 digits) imports with commas separating each 3 digit sequence as if it were formatted as an American number. All non-blank entries in the third column (15 digits) come in as 100,000,000 regardless of what the number actually is.

I have tried both .xls and .csv versions of the sheet with no luck.

Any idea what I am doing wrong?

[kevinmcdonald · Accepted solution]

Solved my own problem! I looked at the field type of the problem fields in the import set and apparently they were automatically set to Floating Point. The field that works was set to String. When I changed the fields in the import set table to String and re-imported the data it came through clean.

I still don't know why this happened, but at least I have a work-around.