The numbers you posted sort in this sequence for me.

2007-2
2007-7
2007-8
2008-1
2008-10
2008-46

Tyro

"Diana Morrison" wrote in message
...
Hello everyone, I've obviously done a terrible job of explaining myself...

2007-1 is year 2007, # 1 is the 1st issue
2007-34 34 is the 34th issue
2007-355 etc.
2008-1
2008-2
2008-3

with an autofilter on each column of the spreadsheet. When I sort in
ascending order (or decending) I get bizzarre results - nothing really in
numerical order. see below.

2008-46
2007-2
2007-7
2007-8
2008-1
2008-10

This happens no matter what I format the cells to.

Diana

"Dave Peterson" wrote:

You chose nice data <vbg:

2007-1
2007-1111
2007-56
2008-200133
2007-5655
2008-20

Sean Timmons wrote:

I just typed in a few into Excel, and it sorted fine...

2007-1
2007-56
2008-20

Do you want it to sort a different way?

And, just making sure, do you want to actually sort the rows? For that,
you
use data - sort, not data - filter...

"Barb Reinhardt" wrote:

I'm guessing you have numbers like

2007-1
2007-10
2007-100

These are text. If you want them to sort "properly", you'll need
numbers
like this

2007-001
2007-002
2007-010
2007-011
2007-100
2007-101

--
HTH,
Barb Reinhardt



"Diana Morrison" wrote:

We use a numbering system to sort certain data, i.e.
2007-1 where 2007 is the year, 1 is just a number - it could go up
to 1000
2008-1 same as above.
How do I sort this using autofilter? Seems so simple...I've tried
to
customize the formatting but couldn't find anything that works.
Thanks,
Diana



--

Dave Peterson