George,

A lot of discussion has gone on about this type of sort...
http://groups.google.co.uk/groups?as...el.*&lr=&hl=en

Also, David McRitchie has quite a bit of information...
http://www.mvps.org/dmcritchie/excel/sorttcp.htm

Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"GStrawley" wrote in message
Hello,
This seems similar to Jaffo's problem of today, but a little different.
I am entering some numbers as part of a decimal classification scheme
similar to the version numbers used in computer programs or the
chapters and subchapters in some books and reports. It is in the form
of "1.1.1, 1.1.2 ...."

I am trying to get Excel to recognize this format as numbers rather
than text so that numbers like 1.1.10 are sorted in the proper sequence
and go after 1.1.9. I tried entering "#.#.#" and even "##.##.##" in the
Format Cells - Special box, but nothing changed when I pasted the
numbers into the cells.

Is there a way of doing this or will I need to parse this
classification number into separate Excel columns?
Thanks,
George