Column format from number to text

[AgnesHU]

Hello!

I changed the format of a column from number to text, but I still receive error message.

It says for the text "could not convert" to number.

Why does it want to still convert to number? How can I solve it?

Thanks!

[v-yiruan-msft]

Hi  @AgnesHU ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[HotChilli]

Is this in Power Query?  What's the data source?

Power Query transforms are a series of steps so it may be that the change to number type is still in one of the query steps even though later on the change to text is attempted.  So please check the query steps.

If you can't get anywhere, please post the code from the Advanced Editor.  And a small data sample.