Jack, 1. Open a new stack, place 2 scrolling fields and 1 button "Modify_Sort" on it
2. Copy (cut & paste) your data into fld 1 - must be 1 number/line 3. Copy the following script into your "Midify_Sort" button on mouseUp -- by Ralph forehand 06/03/05 -- inset leading 0s into numers where needed put empty into card field 2 repeat with i = 1 to number of lines in fld 1 put line i of fld 1 into myNumber if char 2 of myNumber ="." then put "0"& myNumber into line i of fld 2 else put myNumber into line i of fld 2 end if end repeat -- sort modified numbers sort cd fld 2 -- Remove leading Zeros returning numbers to original form repeat with i = 1 to number of lines in fld 2 put line i of fld 2 into myNumber if char 1 of myNumber = 0 then put char 2 to 12 of myNumber into line i of fld 2 else put myNumber into line i of fld 2 end if end repeat end mouseUp 4. Button will put your numbers in the right order. Trust the above helps and Good Luck, Ralph > Greetings, > > I need a field to sort numerically and when I try it I get the result below. > I checked the docs and experimented with the numberformat without success. > Help! > >jack > > > >1.101- >10.101- >10.201- >10.301.1- >10.351- >10.401- >10.501- >11.101.1- >11.151- >2.101- >2.301- >20.101- >3.101- >4.101- >4.991- >5.101.1- >5.151- >5.201- >5.301- >5.351.1- >5.401- >5.451- >5.501- >5.651- >5.701- >6.101.1- >6.201.1- >6.301- >6.401.1- >7.101- >7.151.1- >7.201.1- >7.251- >7.401- >7.501.1- >8.101- >8.301- >9.101.1- >9.351- >_______________________________________________ >use-revolution mailing list >use-revolution@lists.runrev.com >http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution