An alternative solution that works is some situations is to format the column as "Text". However you must do this before pasting the data into the cells or else

An alternative solution that works is some situations is to format the column as "Text". However you must do this before pasting the data into the cells or else it will already be converted. I use this technique for zip codes which can have leading zeros.