In that case, try this formula in B1

=OFFSET($A$1,4-ROW(),0)*1000

Change the 4 to reflect the number of rows you have in column A. Copy the
formula down Column B as far as needed.

HTH,
Elkar


"Cheetah" wrote:

Thanks Elkar except I want to take that cell and multiply by 1000 so I was
hoping I can them in 1 step e.g. ig my nmbers were in A1..A4 I want to be
able to put them in column B where
cell B1=A4*1000
cell B2=A3*1000
cell B3=A2*1000
cell B4=A1*1000

rgds
jc

"Cheetah" wrote:

In a column I have for e.g. numbers
234
111
333
888
but I want to re-arrange them so that the bottom # goes to the top & vice
versa i.e.
888
333
111
234
How do I do this in excel?