This solution will assist where clients are trying to import reports from a CSV file and they appear on the first column. The issue is with Regional settings and it has been tested on Win 7

Windows 7

  – Close the Excel application

  – Click on the Windows/Start button

  – Select Control Panel

  – Select Region and Language

  – Click on Formats Tab

  – Click on Additional Settings

  – Locate the List separator

  – Change the Decimal separator from a full stop (.) to a comma (,) 

  – Then click on Apply then Ok

  – Under the Formats Tab click on Apply then Ok

  – Test the Excel import again

NB: If it does not work, try rebooting the machine, and test again.

Windows 8/10

To change regional settings,

  – go to Start > Control Panel > Regional and Language Options | Windows 10  (Start >type Control Panel and press enter > Region)

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

————————————

This document has been copied from FAVOR.com.ua (https://favor.com.ua/en/blogs/34983.html).
All rights reserved by author of the material. In case of re-publication, the link to the source of the material is strongly required!
Document date: February 5, 2022