Issue with UPC format being changed

[jboschee34]

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]

@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"))

[Anonymous]

Hi @jboschee34 ,

Thank you for reaching out to us with your issue regarding the UPC format being changed in Power Query. I understand how frustrating it can be when unexpected changes occur. I'll be happy to assist you with this. To better understand and resolve the issue, could you please provide some additional information? This will help me diagnose the problem more accurately. Here are a few questions:

1. Are you using Power Query in Excel or Power BI Desktop?

2. Could you please provide the steps you are following to import the UPC data into Power Query?

3. Are you encountering any error messages or warnings when the format is changed?

4. Could you share a sample of the UPC data that is being affected?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[jboschee34]

I was able to change the format in the upload file and it sorted itselt out.