Power Query Problems

Set a Currency Type and Symbol in Excel Power Query

Adam DavisAdam Davis Nov 14, 2026 869 views

Question details

The user wants to set a currency data type in Power Query and display a currency symbol in the results.

Set a Currency Type and Symbol in Excel Power Query
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the query

In Excel, go to Data > Queries & Connections, then double-click the query to open Power Query Editor.

2
Set the column type

Select the monetary column, then use Transform > Data Type to choose Currency or Fixed Decimal Number, depending on your Excel version.

3
Load the results

Select Home > Close & Load to load the query results into Excel. If needed, use Close & Load To to choose a worksheet destination.

4
Apply a currency format

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.

Set the currency type and format the loaded Excel column
Type and display are separate: A currency symbol in the worksheet is display formatting. It does not change the Power Query data type or convert values between currencies.
Free Microsoft Office alternative

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.

Apply currency number formatting to worksheet valuesOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.