Joe

Sort them first in the column?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Joe the Toe" <Joe the wrote in message
...
Hello,

Can anyone help me?
I have a column of numbers as follows:
1
2
3
Using copy/paste special transpose i can put them into a row but only as
follows: 1,2,3
Does anyone know a quick way to put them in this order:3,2,1

Cheers

Joe