View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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?