|
|
|
|
#1
11-18-2023, 08:27 PM
|
||||
|
||||
What I did:
1.click on From Data Range to open Power Query and set source 2. click on Add Column > Custom Column - enter alias field name in place of "Custom" then enter expression: Number.ToText([Cost],"C") Review Number.ToText - Function | Power Query How How do you cast an integer to a string in Excel's PowerQuery - Stack Overflow Last edited by June7; 11-19-2023 at 11:45 AM. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel power query help | ganesang | Excel Programming | 0 | 09-20-2021 01:50 AM |
| Calculate age in power query as of a given date | Marcia | Excel | 1 | 11-12-2020 07:14 AM |
 Format numbers in Power Query
|
Marcia | Excel | 2 | 09-21-2020 12:59 AM |
| Do I need a power query for this one? | shabbaranks | Excel | 5 | 04-10-2019 03:29 AM |
| Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
Windows 10 
Office 2010
Hybrid Mode