Fix Power Query Showing Fewer Decimal Places with Accounting Format
Question details
Users notice a loss of decimal precision when importing spreadsheet data formatted with the Accounting format into Power Query.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Importing financial or numeric spreadsheet data into Power Query for transformation and analysis.
- Observed behavior
- Power Query displays fewer decimal places than expected, appearing to truncate or round the underlying numeric values of cells that use the Accounting format.
Before troubleshooting, verify the actual stored value in your source data by selecting the affected cell and checking the formula bar, as Excel's cell formatting can hide the true numeric precision.
Verify Source Data and Adjust Power Query Data Types
Change the source cell format to verify the raw data, then ensure Power Query uses the correct decimal data type to prevent unintended rounding.
The Accounting format in Excel is strictly a presentation layer designed to display currency amounts cleanly. It does not control how the data is stored. When Power Query imports this data, it might interpret the format and apply a default precision limit. Adjusting the source format and the Power Query data type resolves this.
Select the affected cells in your source Excel worksheet, go to the Home tab, and change the format dropdown from 'Accounting' to 'Number'.
Click the 'Increase Decimal' button in the Number group to reveal the full precision of your stored values before importing.
Open the Power Query Editor, click the data type icon on the left side of your column header, and select 'Decimal Number' to maintain full precision.
Load the transformed data back into Excel, select the final output table, and reapply the Accounting format for presentation.

Remove Automatic Rounding Steps in Power Query
Ensure that no intermediate steps in your Power Query transformation are automatically altering your data types and rounding your numbers.
Handle Data Processing Seamlessly with WPS Office
If you frequently encounter complex formatting quirks and data type issues in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool that makes managing raw data, decimal precision, and accounting formats straightforward without unexpected data truncation.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx or .csv files with zero compatibility issues.
- 3. Manage Data Freely: Easily set your column formats to Number or Accounting using the familiar top ribbon, preserving your exact decimal precision.

Frequently Asked Questions
Why does the Accounting format change my decimal places in Excel?
The Accounting format is designed purely for presentation to align currency symbols and decimal points neatly. It does not alter the underlying numeric value stored in the cell, but it often hides extra decimal places by defaulting to two decimal points.
Does Power Query automatically round numbers upon import?
Power Query does not inherently round raw data. However, an automatic 'Changed Type' step might convert a highly precise decimal column into a 'Currency' or 'Whole Number' data type based on source formatting, which causes it to appear rounded.
How do I force Power Query to show exact decimal values?
To show exact decimal values, ensure the column's data type is explicitly set to 'Decimal Number' in the Power Query Editor. Additionally, verify that the external source data hasn't been rounded prior to import.
Can I apply the Accounting format directly inside the Power Query Editor?
No, Power Query focuses entirely on data transformation, cleansing, and structuring. You should apply visual presentation formats like Accounting or Currency in the final Excel worksheet after the query has loaded the data.




