I have an issue that I can't seem to find any help on. I am by no means an excel expert. Here is my issue, and hopefully someone can give me some guidance.
I have a file that I extracted from a company's database. It's a warehouse bin location master list.
The records are like this: 010101
010201
010301
I need the records to read like this: M.01.01.01
M.01.02.01
Can this done by custom formatting? How do I go about this? I have tried several different ways. There are over 2000 of them, too many to change manually.
I have a file that I extracted from a company's database. It's a warehouse bin location master list.
The records are like this: 010101
010201
010301
I need the records to read like this: M.01.01.01
M.01.02.01
Can this done by custom formatting? How do I go about this? I have tried several different ways. There are over 2000 of them, too many to change manually.
