Column A has the numbers to sort.

enter in B1 =LEFT(A1)
enter in C1 =IF(RIGHT(A1)="'","1",A1)
enter in D1 =LEFT(A1,LEFT(LEN(A1)-1))

extend formula's down the columns
highlight the area and select data sort
sort by column B, then by column C, then by column D.

Come back to us with more samples if this does not work for you.
--
Greetings from New Zealand
Bill K

"Joanne" wrote in message
...
I would like to sort some text which is formatted in column one as:
1'
100
1000'
2
2'
and so on. Any number that does not have an "'" at the end should come
before any number that does and all the 1s, 2s, 3s, etc. should be grouped
together. Is this possible? The result would look like:
1
100
1000'
2
2'

Boy, would I appreciate some help.