Problem with leading zero's, scientific notations, and pasting into a form

I am having a problem with a sheet I use for work, merging the data I get from a downloaded source correctly(also an excel format). I have been in the process of optimizing it to help catch errors be...