Forum Discussion
Text Import Wizard issues
HI everyone, I am having big issues when converting a text file into excel using the text import wizard. In the last step, under the "advanced" settings, I am asked whether I want to use a comma or ...
On the third step you shall select dot and comma mean in your regional settings, but how they are interpreted in the source, i.e. in the file you import.
For example, with importing "12.345,67" select on third step comma as thousand separator and dot as decimal separator. Above text will be converted to number 12,345.67