Please Help: Character Insertion

A

ajarens

Hello:

I have an excel database full of product from my supplier. One of th
columns contains UPC codes. A full UPC code is 11 digits, but for som
reason my supplier omits the number zero in which the first number i
zero. Right now, I have half a list of correct 11 digit codes, and th
other half I need to insert a zero in front og very first digit. I
there any way for me to do this in bulk instead of doing one by one?

for example

12345678999
9999999999 (I need zeroes entered on these in the beginning
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop Excel from dropping leading zeros? 9
Text vs. Number 5
Creating UPC Codes... 2
FormCode - Converting Type-E UPC to Type-A (barcodes) 2
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
Cell format changes when I paste 4
HELP IN CREATING A FORMULA 9
Brain Clog! Help with formula, please 7

Top