Ordering Problem

J

JD

I made a column Index using data from three other colums of the spreadsheet,
and put it in outline form, separating them with decimals. (#.#.#) When I
sort them in ascending order, I get problems like the example shown below.

1.11.110
1.11.111
1.11.113
1.11.152
1.11.38

I want the last one to be above at the top of the list, Excel things it
should go on the bottom because of the 3. Is there a way to fix this?
 
J

JD

Thanks, now how do I automatically make the numbers in the original column 03
instead of 3.
 
S

ShaneDevenshire

Hi JD,

I am assuming that these are number and periods, not formatting?

=LEFT(A1,FIND(".",A1,FIND(".",A1)+1))&RIGHT("00"&MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,10),3)

This formula only deals with the last group, you may still have problems if
your second group, .11., is .2., that is, only one digit.
 
J

JD

Yeah, the middle column would still be messed up. Is there a way I could
just add zeroes to the front of the numbers in the colum that the index is
using?
 
Top