The Comma and Semicolon Issue in Excel Due to Regional Settings when open CSV file

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 :

http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this

Excel 2010 – Object library Invalid

If you have experiencing a problem with Ms. Excel 2010

“Object library invalid or contains references to object definitions that could not be found”

like picture below :

Maybe this solution can solved the problem :

Unregister and then register back the mscomctl.ocx.

Please copy  below script into notepad and then save into mscomctl.bat

regsvr32 /u mscomctl.ocx

regsvr32 mscomctl.ocx

After copy that script, run mscomctl.ocx using administrator privilege.

I hope this solution will help you, if you’re found same problem. 😀

 

Reference Link :

http://support.microsoft.com/kb/2703186 (for another method to solved this problem)