Data Import & Export

Display Excel and Power BI Values with Three Decimal Places

Natalie TaylorNatalie Taylor Nov 12, 2026 870 views

Question details

Convert imported decimal values that are recognized as text and format the resulting numbers to display three decimal places.

How to Display Excel and Power BI Values with 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Power Query Editor

In Power BI Desktop, select Home > Transform data to open Power Query Editor.

2
Select the imported value column

Click the column that contains values such as 41.49 or 29.02.

3
Change the type using a locale

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.

4
Apply the conversion

Select OK, then choose Home > Close & Apply to load the converted numeric column into the Power BI model.

5
Set the decimal display

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.

Convert the Power BI column with the correct locale and format three decimals
Numeric values can now be formatted: After conversion, a value such as 41.49 can display as 41.490 without changing its underlying numeric value.
Format imported decimal values in WPS Spreadsheet

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. 1. Open the imported workbook: Open the Excel file in WPS Spreadsheet and select the column containing the imported decimal values.
  2. 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. 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. 4. Apply a three-decimal number format: Right-click the converted cells, choose Format Cells > Number, and set Decimal places to 3.
Set Number formatting to display exactly three decimal places.Convert text-style imported values into numeric spreadsheet data.Open and edit Microsoft Excel .xlsx and .xls files with format compatibility.Use a familiar, lightweight spreadsheet interface for data cleanup.
microsoft office alternative - wps office

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.