Frank, thanks for the reply.

But, I double click when the black cross appears in the lower right of the
cell that I have written my formula in and nothing happens.


"Frank Kabel" wrote in message
...
Hi
double click on the lower right corner of your formula cell

--
Regards
Frank Kabel
Frankfurt, Germany

Brian wrote:
I have a worksheet with approx. 37000 account numbers.

I need to format another sheet to pull these numbers into a text
format, no problem.

My question: When I want to copy a formula into all 37000 rows, what
is a quick way to select row 1 thru 37000 and paste the formula
without scrolling for 10 minutes?

P.S. I don't want to select the entire column.