Forum Discussion
Decimal separator after CSV import
Hi,
I need some help, please. I'm trying to import a csv file. The problem is that numbers are written with comma decimal separator, but my PC is working with dots as decimal separator.
In the p...
Hi Sergei, your solution works well, except for data including a currency sign. How can I fix these data during the import ?
thanks
JC
In Power Query editor select such column(s), Transform->Replace Values. In Value to Find $ in Replace With nothing, Ok. Select column again, click on icon on icon on the left of header (most probably ABC), apply Currency data type from drop-down menu.