Sorting numbers in a specific way?

[Dno]

Hi,

I was wondering if it is possible in excel to sort numbers in a slightly different way the usual.

If you sort a series or numbers normally you will get:

1
2
3
4
5
6
7
8
9
10
11
12
13
etc

I'd like to make it so numbers are sorted like this:
1
10
11
12
13
14
15
16
17
18
19
2
21
22
23
etc


So number 2 would go after 19 and number 3 will go after 29.

Another GIS program I use sorts numbers this way and I'd like to match them up.

Thanks!

Dino

[Bryan Hessey]

Hi,

I was wondering if it is possible in excel to sort numbers in a slightly different way the usual.

If you sort a series or numbers normally you will get:

1
~~
23
etc


So number 2 would go after 19 and number 3 will go after 29.

Another GIS program I use sorts numbers this way and I'd like to match them up.

Thanks!

Dino

Hi,

in a helper column use =Text(A1,0) and sort on the helper column with 'separately' to the 'Numbers' question.

hth
---

[Dno]

nice one =)

That works perfectly.

Thanks for your help.

Have a great day!

Dino

[Bryan Hessey]

nice one =)

That works perfectly.

Thanks for your help.

Have a great day!

Dino

good to see it worked for you, and thanks for the response.

---