I have an excel file formatted as text with UPC codes. There are a number of them that have two extra leading zeroes in front. See below:
They need to look like this:
If I go into the cell and make the change, all is good, but I have about 4000 of these to do. I tried Find 000 and Replace with 0, but when you do that excel strips the leading zero off, even if you format the find and the replace as text. I've tried custom formatting to no avail as well.
Any other ideas?
Thanks in advance.