Sorting Problems

[Guest]

I don't know if this will help, but can you put a 0 in
front of things that are in bins that aren't double
digits. IE a 3 = 03, a 2 = 02, etc.

 

[Cutter]

The problem is the lack of leading zeros after the last decimal in you
example. If you add a zero before the 2 and the 3 you'll be able t
sort them properly.

3.4.23.02
3.4.23.20
3.4.23.21
3.4.23.22
3.4.23.03

when sorted becomes

3.4.23.02
3.4.23.03
3.4.23.20
3.4.23.21
3.4.23.2

 

[The Wonder Thing]

Yeah, that would work, and I guess it wouldn't be that hard, beyond making it
a little hard to read. I'll do it that way if I have to, but if anyone can
think of a way to do it without, I'm still interested. A macro, whatever.

Thanks, you guys.