Forum Discussion
Re: Power Query Dropping Decimals with Accounting Format
I can't reproduce that
On which Excel platform/version you are?
4 Replies
I am on version 2503, build 18623.20178 64 bit
Edit: even after creating a blank workbook file and creating a new query, PQ still only picks up 4 decimal places when data is in the accounting format, and PQ is attempting to change the data type to Decimal Number
Do you work with .xls or .xlsx files? For them are different behaviour. If .xlsx I have no idea why so.
I am seeing this issue in both .xlsx and .xlsm file types
