If you are likely to have less than 99 sub-folders, then you should
number them 01--, 02--, 03-- etc for the first nine then 10--, 11--,
12-- etc. If you have more than 99 then you should number them 001--,
002--, 003-- .... 010--, 011--, 012-- etc.

Alternatively, you could start them with a--, b--, c-- etc.

Hope this helps.

Pete

On Sep 11, 4:11 pm, Steve G
wrote:
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