#1
|
||||
|
||||
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? |
#2
|
||||
|
||||
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. |
#3
|
||||
|
||||
That is correct. I refreshed the query table several times and the formatted numbers remain. Thank you.
|
|
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 |