Thanks Cimjet. Could you elaborate on "copy down?" Thx

"Cimjet" wrote:

Hi Pookie954
="1"&A1 This formula will add 1 to the numbers, just type in with the right
reference eg:"A!" and copy down.
Regards
Cimjet
"pookie954" wrote in message
...
I have a 5000+ list of phone #s in an excel sheet. I need to add a 1 to
each
of them. The numbers look like this: 9545555555. I wabt to add the 1
prefix without a dash or space. Could someone be so kind as to help this
newbie???