Forum Discussion
Why is power query adding extra numbers to data from excel?
For instance, the excel file which is the data source states 31800044.0307 but in power query it's showing 31800044.030699998. both data types are text in excel and in power query. this is occurring...
Issue was with the file, once the report was opened in xls it tried to transform the project number and was causing the error. I have pulled the original files in using text/csv
Thank you, I will post with them. In the meantime I suppose doing a replace values may help, a lot of them have similar extra digits so hopefully that will eliminate it from the thousands of ones that aren't matching up.
Hi Anonymous,
Is this problem solved? I found a post today documenting a similar issue, hope this helps you.
Why Excel show value on CELL not same as FORMULA BAR - Microsoft Community
Best Regards,
Community Support Team_Gao