Sorting numbers

[Bogy]

I'm using Office 2000, and I'm having a problem sorting numbers. For example

12
12
12
331
331
331
331
3311-
3311-
3311-

When it sorts I would like it to place the larger numbers with the dashes at the bottom so it looks like this

12
12
12
331
331
331
331
3311-
3311-
3311-
I've been beating my head off the keyboard for hours on this, it just can't be that hard, can it

Bogy

 

[Lady Layla]

You are sorting numbers and sorting text --- they dont work togethr. Change the
numbers (those without -) to text and you should get a correct sort


: I'm using Office 2000, and I'm having a problem sorting numbers. For example:
:
: 125
: 124
: 126
: 3312
: 3315
: 3314
: 3311
: 3311-1
: 3311-5
: 3311-2
:
: When it sorts I would like it to place the larger numbers with the dashes at
the bottom so it looks like this:
:
: 124
: 125
: 126
: 3311
: 3312
: 3314
: 3315
: 3311-1
: 3311-2
: 3311-5
: I've been beating my head off the keyboard for hours on this, it just can't be
that hard, can it?
:
: Bogy

 

[Bogy]

Thank You!!! I knew it had to be simple! Thank you, Thank you, Thank you!!


Bogy