Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2020, 03:31 PM
Marcia's Avatar
Marcia Marcia is offline Format numbers in Power Query Windows 7 32bit Format numbers in Power Query Office 2013
Expert
Format numbers in Power Query
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Format numbers in Power Query


Hi, I am using MS 2013, Power Query as add-in. There is no modelling tab so how will I format the number columns with a comma separator in Power Query?
Reply With Quote
  #2  
Old 09-20-2020, 02:00 PM
p45cal's Avatar
p45cal p45cal is offline Format numbers in Power Query Windows 10 Format numbers in Power Query Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

I think you do it in the resulting table - it will keep the settings between updates; try to select whole columns in the table while you edit the formats.
Come back if you find the formatting is not retained between refreshes.
Reply With Quote
  #3  
Old 09-21-2020, 12:59 AM
Marcia's Avatar
Marcia Marcia is offline Format numbers in Power Query Windows 7 32bit Format numbers in Power Query Office 2013
Expert
Format numbers in Power Query
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by p45cal View Post
I think you do it in the resulting table - it will keep the settings between updates; try to select whole columns in the table
That is correct. I refreshed the query table several times and the formatted numbers remain. Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Power Query to combine multiple tables of unequal number of columns ProudLiberal Excel 1 01-07-2020 07:54 PM
Issue with Power Query editor/Data model-Excel 2016 Meg Mika Excel 0 11-12-2019 01:05 PM
Do I need a power query for this one? shabbaranks Excel 5 04-10-2019 03:29 AM
Issues Using Power Query file in Excel 2016 and then in 2013 bld9936 Excel Programming 0 02-27-2017 12:50 PM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft