There are a problem with excel 2010 that happened to my customer.When opening standard CSV (Comma Separated Values) files in Excel 2010 you may find that Excel did not recognize the fields and simply displays all data in the first column.
The problem is:
- The standard field delimiters for CSV files are commas “,”
- On American Windows versions, the comma is set as default for the “List Separator”, which is okay for CSV files.
- But on European Windows versions this character is reserved as the Decimal Symbol and the “List Separator” is set by default to the semicolon “;”
After search the problem in google, I found a way to solved it. The solution is to change regional settings.
Please follow below step to solved it :
- go to Start | Control Panel | Regional and Language Options
- Click Additional Settings
- For Decimal Symbol, enter a dot “.”
- For List Separator, enter a comma “,”
Now, when you open a CSV file in Excel it will automatically find the data fields and open it appropriately. 😀
References Link :