Forum Discussion
jboschee34
2 years agoFrequent Visitor
Issue with UPC format being changed
My UPC format if being changed from numbers in PowerQuery to text in Desktop without my doing. This is causing the last half of the numbers to become 0. Anyone know how to fix this? Thanks!
amitchandak
2 years agoSuper User
jboschee34 , refer if the old solution convert text can help
https://community.fabric.microsoft.com/t5/Desktop/Power-query-help/td-p/2812927
using
=Number.ToText(Number.From([Column]),"G"))