Excel wants to express a number stored as a string in scientific notation

Ah the weirdness never ends. I needed to preserve a big long number as a string (a census data value as fips state, fips county, tract number, and block number). Excel apparently wants to keep it in scientific notation even though I am pasting values from a number formatted as an integer. I found a way to get it to work here so I wanted to book mark this somehow.

In case something happens to that link, essentially what was told there was to use the UPPER Excel function on the column and then copy and paste the values from that result. That seemed to work for me. Ah the weirdness. It truly never ends.