Sorry for the vague question. Let me explain.
I am pulling data from my company's database. One of the columns is the line number on a Sales Order. However, the way our system works is that if an SO line item is composed of multiple pieces (an assembly) then each of those pieces are a sub-set with their own numbering scheme.
The numbering scheme for these sub-items appears to Excel (and a normal human being for that matter) as a decimal. In other words, sub-item #12 within SO line #38 is stored in the column as "38.12". So when I sort by this column I'm getting sequential results like:
38.10 38.1 38.11 38.12 38.13
In actuality, the sequence should be 38.1, 38.2, 38.3, ..., 38.10, 38.11, 38.12 etc. I'm definitely not a programmer, but I think this may be an easy fix for some of you that know programming. How do I order these rows correctly?