Apr 05 2022 01:35 AM
I would like to ask for your help with the transformation of the CSV file into an excel file. After I download the CSV and import it, there’s a problem with the separation marks. (Excel version: 2102) I use UTF-8 code for character but -if I’m right-the numbers are not affected of it. Furthermore, during the import I use comma as field separation (Delimiter). I must highlight that the import of the downloaded CSV file perfectly works in the earlier version of excel, therefore I assume that the problem will be with the updated version of it (version: 2102).
The problem is: The numbers appear with "wrong" separation marks. When we load the data, it uses “dot” for decimal separator and “comma”for thousand separator. Nevertheless, we would like to use “comma”for decimal separator and “space” or “nothing” for thousand separator.
I tried to change them with “ctrl+f and replace” but obviously this is not a solution for a long term. I have more than 30 columns to change.
(The settings of excel and windows use the right separator)
This is the exact format what I want. If you have any idea that would lead me to solve this insane, irritating problem, I would be the happiest person in the world.
Apr 05 2022 03:30 AM
How do you import csv file, using Power Query or 3-steps legacy wizard?
Apr 05 2022 03:45 AM
Apr 05 2022 04:24 AM
It shall work with both. Just with legacy wizard you may define separators on third step
with Power Query is through encoding and delimiter with converting texts to numbers using locale.