This may be too simple....but, can you use 2-digit prefixes?
01--Comments from Joe Smith
02--Comments from the Public Affairs Directorate
03--Spreadsheets of Steve G
etc

Those will sort in the proper order.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)




"Steve G" wrote in message
ups.com...
This is not the perfect forum for the question below but I am sure the
Excel experts have at least thought of this issue.

I would like to number sub-folders in a directory (each sub-folder
might contain Excel, Word, PDF, or text files or any combination
thereof) such that the folders are in numerical order, and not be
date.

For instance:

1--Comments from Joe Smith
2--Comments from the Public Affairs Directorate
3--Spreadsheets of Steve G
4--
5--
6--
7--
8--
9--
10--

Unfortumately the folder beginning with 10-- appears after the folder
"1--Comments..." when I sort on the folder name. I would like the
folder beginning with "10--" to come after the folder beginner with
"9--". I would like a folder beginning with "11--" coming after the
folder "10--".

If anyone has a solution with or without VBA I would be most grateful.

Steve G