sorting text and numbers

[Kierrica]

I would like something like FILE_1 through FILE_10 to be sorted in numerical order, not FILE_1 FILE_10 FILE_2 FILE_3.... etc.

is there a way to do this!? I tried the custom format but it doesn't accept what I put in

 

[lenze]

See the help topic
Create a custom fill series or sorting order

 

[Kierrica]

thanks, i did what it told me, but i don't know how to apply it to my data.

 

[Kierrica]

hah, nevermind, i figured it out
thanks!

 

[lenze]

Once you've created a custom list, then select your data range and choose Data>Sort. Click on the options button and change the Normal type to your custom list. Click OK
This message was edited by lenze on 2002-08-27 13:41