Error converting text to decimal number

[Syndicate_Admin]

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

[Syndicate_Admin]

Thank you very much, this worked for me

[rsbin]

@Syndicate_Admin ,

Glad I could help.  Please don't forget to accept it as a Solution.

Kind Regards,

[rsbin · Accepted solution]

@Syndicate_Admin ,

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]

What error are you seeing? Can you supply a sample row that does not convert?