Add leading #'s to a value

G

Guest

I have a list of UPC's in Column A. Each UPC needs to have a series of
numbers added in front of the current UPC. How can I do this for the entire
column at once?

Ex.

Col A

0-35000-1

Would like it to read as such: 12340-35000-1

Thanks for any help.

Mike
 

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
Does anyone know how to convert UPC's? 1
How do I get Excell to recognise 0 at the beginning of a number? 3
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
How do I format cells to show the number 0 as first number in seri 2
Leading zeroes get dropped when converted to text 8
Keeping leading 0's 4
keeping leading 0's when formatting cells 3

Top