I have two series of numbers in the format B1234
and B12345
. When I sort in ascending order, I get all the numbers starting with B12345
and then all of those from B1234
on.
To counteract this problem, I inserted zero in between B1234
to get B01234
. When the numbers are converted to this format, I am able to get the desired result.
Can you help me inserting zeros?