"janey" wrote in message
...
I have a table which I need to sort, e.g.:

2000
2039B
2026
2167
2239
2242

When I run Sort, I get
2000
2026
2167
2239
2242
2039B

Why does 2039B come at the bottom rather than between 2026 and 2167?

Because numbers are numbers and are sorted numerical. Other data is alpha
numeric which are sorted in order but after numerical data. You could try
adding a column for the alphabetical element and sort on the numerical data
(but include the alpha numerical date in the sort range) and that will be
OK.

Bill R