How to make the Currency Format stick in the Excel sheet after refreshing a Power Query table

Опубликовано: 29 Сентябрь 2024
на канале: Celia Alves - Solve & Excel
4,347
53

When we load data from Power Query into Excel, sometimes number formatting is not shown in the Excel sheet as shown before in Power Query editor. We change the number format in the Excel table, but we may lose that formatting when we refresh our query. Watch this video to learn how to prevent that from happening.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

LIVE CLASSES on YouTube every week: https:www//   / celiaalvessolveexcel  

Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia



Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn:   / celiajordaoalves  

Facebook:   / solveandexcel  

Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada