I have two series of numbers in the format
B12345. When I sort in ascending order, I get all the numbers starting with
B12345 and then all of those from
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?