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