Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbering folders
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
folders not showing | Excel Discussion (Misc queries) | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
XL 07 Initializing Folders | Excel Discussion (Misc queries) | |||
Keep different views for different folders, not the same for all? | Excel Discussion (Misc queries) | |||
Linking to folders | Excel Discussion (Misc queries) |