Forum Discussion
I want to change all this values
Igorfm7 I believe your system uses comma as the decimal separator. That's why most of the numbers are left aligned and you can't increase the number of decimals. They are seen as texts.
You mention Power BI. Then I suggest you use Power Query (also part of Power BI) to transform the texts that look like numbers to suite your locale.
When I copy the data from your post I get numbers directly as my system uses the point for decimals. See attached. When you open that file it should be automatically 'translated' into numbers for you also.
Igorfm7 Well, if you don't know about or don't want to use Power Query despite the fact you work in Power BI, you can select (in Excel) all the 'number columns' and then Ctrl-H (Find & Replace) and replace decimal point with comma.
- I tried like that and doesn't work.
Igorfm7 What does that mean "It doesn't work"? What did you try exactly?