Forum Discussion
Error changing data type obtained from excel
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
or you can remove the euro symbol in power Query and then change the data type.
4 Replies
or you can remove the euro symbol in power Query and then change the data type.
ok works. Thank you.
Syndicate_Admin , I think imported data is coming as text, not as a number. Remove format on excel and then import.
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.
