Forum Discussion
Gregmac
Jan 13, 2019Copper Contributor
Import CSV to Excel
Greetings would appreciate some help. New laptop with windows 10 & office 365. Unable to download csv. files to excel & separate info to columns with comma of the csv format. Region settings English ...
SergeiBaklan
Jan 13, 2019Diamond Contributor
Please clarify what is your last sentence means
list separator is a comma & even resetting, double OK button & reboot doesn't change the format
What is your default list separator, comma or not?
You tried to change it, from what on what?
Gregmac
Jan 14, 2019Copper Contributor
Hi Sergei,
thanks for your response, apologies for my late return.
If I to 'Control Panel', 'Region', 'Formats', Additional Settings' - the list separator is already a comma , Tried re entering it & then 'apply' didn't work, read somewhere double click 'OK' also didn't help. Then tried with rebooting, but still no help. Region settings are all identical to my previous laptop, but perhaps something has been changed now.
- GregmacFeb 24, 2020Copper Contributor
Greetings
Old story line but the answer to this question was found....
Regional & language settings, Additional date & time & regional settings - south africa, english south africa Change date time or number format - all south africa Additonal settings - decimal . - list seperator , Regional & language settings, Additional date & time & regional settings - south africa, english south africa Change date time or number format - all south africa Additonal settings - decimal . - list seperator , Location - south africa