View Single Post
 
Old 11-18-2023, 08:27 PM
June7's Avatar
June7 June7 is offline Windows 10 Office 2010
Novice
 
Join Date: Nov 2023
Posts: 20
June7 is on a distinguished road
Default

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.
Reply With Quote