Error changing data type obtained from excel

[Syndicate_Admin]

Good.

I have an Excel with four records and one of the columns is in currency format, Power Query detects it as text format, when I try to transform it to integer with decimal or currency it gives me error, how can I solve it or what fails?, I put the captures.

Original Excel in currency format

After importing it into Power Query

ERROR. When modifying the data type

   

Greetings

[Syndicate_Admin · Accepted solution]

or you can remove the euro symbol in power Query and then change the data type.

[Syndicate_Admin]

ok works. Thank you.

[amitchandak]

@Syndicate_Admin , I think imported data is coming as text, not as a number. Remove format on excel and then import.

[Syndicate_Admin]

Good, I have tried to remove formats or put it in a thousand ways and it always gave me error, I had to create a new clean column and put the data, so it works for me.

Thank you.