Display Excel and Power BI Values with Three Decimal Places
Question details
Convert imported decimal values that are recognized as text and format the resulting numbers to display three decimal places.

- Product
- Microsoft Excel and Microsoft Power BI
- Device & OS
- not provided
- Scenario
- The user imports values such as 41.49 and 29.02 and wants them displayed with three decimal places.
- Observed behavior
- The imported values may remain text because the source decimal separator does not match the regional settings, preventing numeric decimal formatting.
Check whether the imported values are left-aligned or show a text warning, as these signs can indicate that they are stored as text. Confirm whether the source file uses a period or comma as its decimal separator before choosing a locale.
Convert the Power BI column with the correct locale and format three decimals
Use this method when values are imported into Power BI as text because the source file uses a different decimal separator than your regional settings.
Changing the display format alone will not add decimal places to text. Convert the column to a decimal number using the locale that matches the imported data first.
In Power BI Desktop, select Home > Transform data to open Power Query Editor.
Click the column that contains values such as 41.49 or 29.02.
Select Transform > Data type > Using Locale. Choose Decimal Number, then select the locale whose decimal separator matches the source data, such as English (United States) for periods.
Select OK, then choose Home > Close & Apply to load the converted numeric column into the Power BI model.
In Power BI Desktop, select the column in Data or Model view, open Column tools, and set Format to Decimal number with Decimal places set to 3.

Format converted numbers to three decimal places in Excel
Use this method when the values are already recognized as numbers in Excel, or after you have converted imported text to numbers.
Convert text decimals to numbers in Excel using the matching separator
Use this method when Excel imports decimal values as text and the standard number format cannot be applied.
Convert Imported Decimal Text and Show Three Places in WPS Spreadsheet
WPS Spreadsheet lets you convert imported text values into usable numbers and apply a three-decimal Number format in a familiar spreadsheet workspace. It is a practical way to review decimal separators and present imported data consistently.
- 1. Open the imported workbook: Open the Excel file in WPS Spreadsheet and select the column containing the imported decimal values.
- 2. Check whether the values are text: Click a value and inspect the formula bar; if the value is treated as text, use the column conversion tools or correct the decimal separator in the source data.
- 3. Convert the selected values to numbers: Select the text values, open Data, and use the available text-to-column or conversion option to parse the values with the correct separator.
- 4. Apply a three-decimal number format: Right-click the converted cells, choose Format Cells > Number, and set Decimal places to 3.

Frequently Asked Questions
Why does Excel not let me show three decimal places for imported values?
The values may be stored as text rather than numbers. Convert them to numbers first, then select the cells and use Format Cells > Number > Decimal places: 3.
How do I use a period as the decimal separator in Power Query?
In Power Query Editor, select the column and choose Transform > Data type > Using Locale. Select Decimal Number and choose a locale that uses a period, such as English (United States).
Will formatting a value as 29.020 change its value?
No. Number formatting changes only the displayed precision. The numeric value remains 29.02 unless you use a calculation or rounding function to alter it.
Where can I set three decimal places for a Power BI column?
After the column has a numeric data type, select it in Data or Model view. Open Column tools, choose Decimal number as needed, and set Decimal places to 3.
What should I do if the source data uses commas instead of periods?
Use a locale that treats commas as decimal separators when converting the column. In Excel, you can use Data > Text to Columns > Advanced; in Power Query, use Transform > Data type > Using Locale.




