When importing an Excel file the numbers get formatted

[natalliar]

I have an Excel file with the following structure:

Name         Amount

aaaa             1234

When I import this file 1234 is displayed as 1,234. The cell is General type in the file.

How to prevent numbers form being formatted while import?

[pankaj_puniani · Accepted solution]

When file is imported, staging table column 'Amount' will get assigned to type 'Integer' & it formats the values by default according to Integer format. There are 3 ways to resolve it:

• On Excel sheet change the format to Text, but it has to be done before staging table is ever created. Once staging table is created, this solution won't help. Please refer to other 2
• Change staging table column 'Amount' from   type 'Integer' to 'String'
• Set an attribute on Amount filed

        To do this:

                  1) Open the import set form.

                  2) Right click on the label of the location field that is having the issue.

                  3) Select "Personalize Dictionary".

                  4) Scroll down to the "Attributes" and click "New".

                  5) for the "Attribute" enter "Format" and for the Value enter "none" (literally, the word none). Save

                  6) Reload the import.