Roger, many thanks that worked like a dream.

"Roger Govier" wrote:

Hi Arran

Try using a helper column. In the helper column, enter
=--(LEFT(A1,LEN(A1)-2))
and copy down as far as required.
Mark both columns and sort by the helper column.

--
Regards

Roger Govier


"Arran" wrote in message
...
I cant seem to sort 25th 10th 30th 21st 2nd etc entered data to display
as
2nd 10th 21st 25th 30th in descending . All cells have been formated
as text
before data entered. I am using Excel 2003