Forum Discussion
AdministratorError converting text to decimal number
Hello
I need urgent help, I am important data from an excel which has a column of monetary value, when importing it in power query it recognizes me as text, but when converting it I run the decimal point, for example from 0.27 to 27 or 8.20 UN 820
As text
In decimal
I already tried changing the format of the data in the excel, such as currency, numeric, general and nothing works for me.
Thanks a lot
In Power Query, try as a first step, use Replace Values to change the "," with a period "."
Then you should be able to change it to a decimal number properly.
4 Replies
- rsbin
Community Champion
In Power Query, try as a first step, use Replace Values to change the "," with a period "."
Then you should be able to change it to a decimal number properly.
- ToddChitt
Super User
What error are you seeing? Can you supply a sample row that does not convert?
Syndicate_AdminThank you very much, this worked for me
- rsbin
