 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2007numbering 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 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) > This is not the perfect forum for the question below but I am sure the > Excel experts have at least thought of this issue. [quoted text clipped - 26 lines] > > Steve G Thank you Pete_UK and Mr. Ron Coderre. Your solution was simple. I will start my folders with 01, 02, 03, etc. I will never have more than 99 folders. And if I by chance I do, then I will renumber 01-- to 001--, 02-- to 002--, etc. The solution was obvious to you both and I feel foolish for asking. But I am very grateful because this will make things work for me. Thank you again. Steve G You're welcome - a fresh pair of eyes, as they say ... Pete On Sep 11, 5:14 pm, Steve G <emailfromandtome-softwareus...@yahoo.com> wrote: > Thank you Pete_UK and Mr. Ron Coderre. Your solution was simple. I > will start my folders with 01, 02, 03, etc. I will never have more [quoted text clipped - 6 lines] > > Steve G 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 <emailfromandtome-softwareus...@yahoo.com> 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. [quoted text clipped - 26 lines] > > Steve G |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.