# Putting a list of numbers in chronological order

#### cfarley

##### New Member
Hey there. I know how to put a list of numbers in chronological order, but is it possible to do this specific to the 3rd digit in a number. For example, if you have these #'s:
745678, 923456, 656789, & 834567

Can you arrange them in chronologic order according to the 3rd digit?
923456
834567
745678
656789

Hope this makes sense!

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Norie

##### Well-known Member
Chester

Chronological order?

Isn't that for dates?

Do you mean numerical order?

If you do then the only way I can think of doing that would be to extract the 3rd digit to a helper column and use that in the sort.

#### Jonmo1

##### MrExcel MVP
You could with a helper column...
If those numbers are in column A, in B1 put a formula

=--Mid(A1,3,1)

Then sort by column B.

#### brian.wethington

##### Well-known Member
you could use this formula in a helper column

=RIGHT(A1,LEN(A1)-2)

Drag down as needed then sort and then if you would like you can remove the formula.

#### cfarley

##### New Member
Thanks!

I appreciate the help...and yes I did mean numerical order. Thanks again.

Replies
10
Views
405
Replies
4
Views
144
Replies
1
Views
95
Replies
1
Views
58
Replies
3
Views
132

1,186,365
Messages
5,957,445
Members
438,306
Latest member
Crystal_Blue

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back