Hello, I have a spreadsheet with a column of UPC numbers, some of which
need to have leading zeroes, so I set up a Custom number format with 11
zeroes (00000000000) so that they all display with the correct number of
digits. However, I eventually need to convert these columns to text for
a data import I’m doing, and when I do so, the leading zeroes
disappear.

I need a way to actually have these leading zeroes become part of the
value in the formula bar so I don’t lose them when I convert to text.
The only way I’ve been able to do it so far is to paste the values into
Notepad, format the column I want to paste into to text, and then paste
the data from Notepad back into Excel. I figure there’s GOT to be a way
to skip this step using Notepad, but I’ve no idea what it is. When I’m
dealing with thousands of UPCs, the Notepad solution is going to be
really cumbersome. Can anybody help me?


--
Jason Grunert
------------------------------------------------------------------------
Jason Grunert's Profile: http://www.excelforum.com/member.php...o&userid=37115
View this thread: http://www.excelforum.com/showthread...hreadid=568465