How to remove scientific notation from Number Column in query editor

I have tried to change the locale to english(us), rounding, transforming the text first, etc.    These are ID's, so I need them to build relationships between tables. They should not be in scientif...