Convert Long Part Number List to "Text" Format??

**TestMailinator** · 04-20-2015, 09:57 AM

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)?

**AlKey** · 04-20-2015, 10:10 AM

Try this formula

=TEXT(A1,"#")

Row\Col	A	B
1	2.09784E+14	209784209720429
2	1.23457E+15	1234567891011120
3	2.09784E+14	209784209720429

or you can also format cells: Custom, and enter #

**TestMailinator** · 04-20-2015, 11:01 AM

Thank you, that did the trick. I have a second question now.

I have my new column of text data that works great. In a separate sheet I have to reference these text numbers in the "text" format. When I type "=A1" into a cell formatted as text I get the exact output =A1 displayed. Not the formula. That exact text string =A1. Of course that is to be expected. How do I get around this?