Dave, I'm going with your suggestion - can't get anything else to work.
Thanks for the input everyone.
Diana

"Dave Peterson" wrote:

I would have guessed that it wasn't right.

I would have guessed:
2007-1
2007-56
2007-1111
2007-5655
2008-20
2008-200133

So it sorts by year, then by issue.

I think I'd put the values in separate columns (even using data|text to columns,
delimited by hyphen) and then sort by those two columns.

Sean Timmons wrote:

The below sorted as

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

for me.. Wouldn't that be right?
"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


--

Dave Peterson