Highlight the data in A1:A5 then click on Data | Sort and select
Descending then OK.

Hope this helps.

Pete

On Jan 15, 11:52*am, Bobby wrote:
I have a column formatted as text, I want to reverse the numbers around
a1 1 * * * * * * * * * * * * * * * * *a1 5
a2 2 * * * * * * * * * * * * * * * * *a2 4
a3 3 * * * will look like this * *a3 3
a4 4 * * * * * * * * * * * * * * * * *a4 2
a5 5 * * * * * * * * * * * * * * * * *a5 1
Take #5 and move it up to row a1 #4 move to row a2 #3 stays put, #2 move it
to a4 and #1 move to a5. Can this be done with Excel. I need it simple.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * *Thanks Bob