Forum Discussion
Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only ...
The "Accounting" label is purely for presentation, not data storage. It's designed to cleanly display currency amounts—not preserve mathematical precision.
Try this?
Set the cell format in Excel to "Number" (not "Accounting") before importing.
If using Power Query from external sources, make sure you're not importing from an Excel range that’s pre-formatted with Accounting.
You can reapply Accounting format later after the data is loaded and transformed—only in the final presentation layer (Excel, Power BI, etc.)
Please read my entire post. I am aware of what you are saying.
