Ordering Problem
Hi,
The last entry must be 1.11.038
--
Cheers,
Shane Devenshire
"JD" wrote:
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?
|