Set a Currency Type and Symbol in Excel Power Query
Question details
The user wants to set a currency data type in Power Query and display a currency symbol in the results.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Preparing a monetary column in Power Query before loading it into an Excel worksheet.
- Observed behavior
- Assigning the Currency data type in Power Query does not automatically display a currency symbol in the editor.
Open the query in Power Query Editor and identify the column containing monetary values. Check that the values can be converted to numbers before changing the column type.
Set the currency type and format the loaded Excel column
Use Power Query to set the monetary data type, then apply a currency number format in the worksheet to show a symbol.
The Power Query currency type controls numeric precision and range; it does not control the displayed currency symbol. The fixed decimal number type uses four decimal places.
In Excel, go to Data > Queries & Connections, then double-click the query to open Power Query Editor.
Select the monetary column, then use Transform > Data Type to choose Currency or Fixed Decimal Number, depending on your Excel version.
Select Home > Close & Load to load the query results into Excel. If needed, use Close & Load To to choose a worksheet destination.
Select the loaded monetary cells in the worksheet. On the Home tab, open the Number Format list and choose Currency, or open Format Cells > Number > Currency to select a symbol and decimal places.

Format monetary values in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with spreadsheet files. Its familiar interface and Excel format compatibility make it easy to open existing workbooks and format monetary values, though it does not fix Excel Power Query behavior.

Frequently Asked Questions
Why is there no currency symbol in Power Query Editor?
The Currency or Fixed Decimal Number type specifies how values are stored, not how they are displayed with a symbol. Load the query into Excel and apply a Currency number format to the worksheet cells.
Where can I choose a different currency symbol in Excel?
Select the loaded cells, open Format Cells, and choose Number > Currency. Select the symbol and decimal places you want.
Is Fixed Decimal Number the same as the currency type in Power Query?
Power Query may label the currency type Fixed Decimal Number. It stores values with four decimal places and does not automatically add a currency symbol.
Does applying a currency format convert the amounts to another currency?
No. Home > Number Format > Currency changes the display, not the underlying value. Converting between currencies requires an exchange rate and a calculation.




