Forum Discussion
Why is power query adding extra numbers to data from excel?
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
Hi Anonymous ，
After testing, perhaps the problem lies in the data of the EXCEL workbook. This is beyond my knowledge and you can ask questions here.
In the meantime, I will continue to look for the cause of the problem, and I will get back to you as soon as there is progress.
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
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