By NOT formulas:
Select A1:A10 (or wherever the data are), click on the leftmost cell to
contain the results, use Paste Special & click the "Transpose" checkbox.
By Formulas:
If your range is 10 rows x 1 column, select 1 row x 10 columns, then enter
this formula via ctrl/shift/enter:
=TRANSPOSE(A1:A10)

"jhawk22" wrote in message
...
I'm looking for the formula that will take numbers in vertical cells
putting
them in horizontal cells. I'm copying from a worksheet that has numbers
listed in columns and need to put them into cells that are in rows.

Thanks