Power Query and cell formatting

[RodneyW]

Good morning. I'm using Power Query to import some data. When I update data in the original file, then refresh in the final file, some of the number formatting doesn't stick. For example, some cells should be formatted as % but they appear as numbers with decimals. IE 68% shows up as .68 and I have to manually change it to %. IS there anyway to avoid this step?

Thanks in advance

 

[Peter_SSs]

That helped. THANK YOU

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.