Hello KWBock,

Neither Excel nor VBA has a sorting method to do what you want. A
custom sorting algorithm would have to be written in VBA to accomplish
the task. Depending on how elaborate the naming convention is, the time
needed to construct such a sorting algorithm may out way the time it
takes to add in the zeroes. If you have a large amount of data, then
spending time on the algorithm would be worth the effort.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=381394