Hello
I've got a spreadsheet and I've entered many cells with data in this format A1-1-1, A10-2-10, B11-11-2 etc etc.
These are locations on shelves so A1-1-1 to A1-1-12 represents one shelf, my problem is that when I sort the column it ends up like this.
A1-1-1
A1-1-10
A1-1-11
A1-1-12
A2-1-2
.
.
A2-1-9
Is there a formula or some kind of format I can use so I can put a zero at the beginning of the single numbers? Also I would prefer the format to be A1-1-1 but I just need Excel to know that a 1 is a 01 and not 10.
Any help would be much appreciated
I've got a spreadsheet and I've entered many cells with data in this format A1-1-1, A10-2-10, B11-11-2 etc etc.
These are locations on shelves so A1-1-1 to A1-1-12 represents one shelf, my problem is that when I sort the column it ends up like this.
A1-1-1
A1-1-10
A1-1-11
A1-1-12
A2-1-2
.
.
A2-1-9
Is there a formula or some kind of format I can use so I can put a zero at the beginning of the single numbers? Also I would prefer the format to be A1-1-1 but I just need Excel to know that a 1 is a 01 and not 10.
Any help would be much appreciated