Forum Discussion
Solved
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 m...
or you can remove the euro symbol in power Query and then change the data type.
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.
