Convert numbers to text

[Rhonda]

I have a worksheet where column A is a list of numbers
that are calculated from formulas. I would like to
convert the numbers shown in column A to text so that the
cell can be copied and pasted to another worksheet. Is
that possible? Help!

 

[Rhonda]

Ken - You are a LIFESAVER! Thanks so much.... worked like
a charm. Have to admit I have never used the Paste
Special function. Wish I had one of you in my hip
pocket. The things I could learn..... Thanks again.
Rhonda

-----Original Message-----
You don't need to convert them - Just copy them, select

where you want to paste them in your new