sorting columns that contain values other than numerics

hi,

original columns on Left hand side... after sorted by col C then by B- (Ascending) results I receive are on the right hand side.

within the data certain rows have (.) in them these need to be here as they represent a dicontinuation of products.

I am doing a rank on these columns- for a proper ranking result I need the dots (.) to be at the bottom of the list once I have sorted it. The way I have been doing this so far is after manually sorting as shown on the right I have been manually cutting the cells with (.) and pasting them at the bottom.

sorting.xls

your help is appreciated

Thanks
stats09


B C B C
100 2549 . .
785 587 . .
124 421 . .
156 156 . .
154 451 . .
1027 7201 . .
125 521 . .
325 523 . .
180 810 . .
996 699 . .
198 894 3258 8523
. . 1027 7201
. . 1356 6531
. . 1356 6531
. . 2365 5632
. . 3127 2550
750 570 100 2549
569 965 100 1000
155 551 100 1000
2365 5632 100 1000
126 621 579 975
657 756 669 966
117 711 569 965
3258 8523 198 894
194 491 180 810
100 1000 857 758
156 156 657 756
114 411 117 711
. . 996 699
. . 456 654
412 421 126 621
750 570 785 587
200 250 750 570
3127 2550 750 570
579 975 155 551
150 510 625 526
100 1000 625 526
625 526 325 523
325 523 325 523
112 211 325 523
1356 6531 125 521
857 758 150 510
123 321 194 491
456 654 154 451
669 966 124 421
. . 412 421
. . 114 411
. . 123 321
. . 200 250
100 1000 112 211
625 526 112 211
325 523 156 156
112 211 156 156
1356 6531 . .

not at all clear that! put it in a work book and attach it

btw thats sorted descending!
you could use a helper column say d and put something like
=IF(ISTEXT(c2),0.01,c2)
then sort by d then b