View Single Post
  #2   Report Post  
L. Howard Kittle
 
Posts: n/a
Default

One way is to use a helper column next to your data and enter 1 at the top
and fill down holding the CTRL key down until you reach the bottom of your
data. Then sort both columns using the 1 thru N column as the sort column.

HTH
Regards,
Howard

"shockwave_dave" wrote in message
...
I've a long column of numbers in excel which i need to flip round or
invert
but dont know how. I cant use the sort function as it only sorts it in
ascending or descending order but i want to reverse the order of the
numbers
so that bottom becomes top and top becomes bottom for example. Thanks