I am trying to import some excel spreadsheets that contain a variety of UPC formats. Some of the UPCs contain a zero for the first number and when I remove the "-" is takes the zero away. Here are some examples:
Before:
A1: 011548-554782
B1: 0-14575-66871-3
After:
A1: 11548554782
B1: 14575668713
What I really want is this:
011548554782
014575668713
I feel like it is just a simple matter of choosing the correct format for the cell but I can't figure it out.
Any thoughts?
Before:
A1: 011548-554782
B1: 0-14575-66871-3
After:
A1: 11548554782
B1: 14575668713
What I really want is this:
011548554782
014575668713
I feel like it is just a simple matter of choosing the correct format for the cell but I can't figure it out.
Any thoughts?