I have a list of part numbers that are fairly long (eg, 209784209720429). There is a whole column of them in general format. When I convert this column to a text format all the numbers get changed to a scientific notation (eg 2.09784E+14).

How do I get them to stay in the part number format I want (eg, 209784209720429)?