I am having issues with leading zeros dropping off when I copy/paste into cells. I do Vlookup and convert my columns to text to be sure that I will get a return on my lookup. The numbers I use are manufacturer or vendor part numbers such as 02273480. In some cases, when I add this number into a cell, the leading zero is gone and I will not get a match. I know that if I add ' to the cell first, the zero stays but when I am pasting 70-100,000 lines at a time, that isnt an option. any help would be great.
Thanks
Kelly
Bookmarks