PQ: Formatting Cells that contain Text & Numbers.

[countryfan_nt]

Hello friends! Hope all is safe & Healthy,

I have an error when using PowerQuery to combine CSVs. A certain Column has letters and numbers. How do I not let the errors appear; i.e. how do I let the format changing to display the letters and numbers in the column cells? The image should explain.

Thank you so much in advance!

 

[Matt Allington]

I can see in the column heading the column is formatted as date. There must be a step somewhere that turns the format from “any” to “date“. Change that step to format the column as text

 

[countryfan_nt]

Tank you Matt, I did, please see the image here. Still after converting to Text, getting error. Please help.

 

[pjmorris]

Matt's key point was that somewhere in the list of transformations in your PowerQuery the format of that column is changed to Date, that is what caused the problem. Simply changing the format back to text won't clear the problem. You need to look back up the list of steps until you see where the change occurred.

HTH

 

[sandy666]

remove all change type lines for that column then set type text