The easiest way to do this:
Insert a new column (it's only temporary)
Select the cell in that column on the same row as your first row of data.
Enter the number 1.
With that cell selected, click edit, fill, series.
Change series in: to columns.
Set a stop value of 1000.
Sort your table by the new column in descending order.
Delete or hide the "cheat" column.


"Steven Sinclair" wrote:

I have a column of 1000 items.

I would like to be able to "reverse" the current order of the column, but
cannot use the sort feature as I have numbers mixed with text. Every time I
attempt to use the sort feature, everything is all messed up.

So if I have this...

a
1
2
b
3
4
5
c

I need this...

c
5
4
3
b
2
1
a

How can I accomplish this programmatically?

Thanx.