Hi Lisa,
See InsertPrefix macro in
http://www.mvps.org/dmcritchie/excel/join.htm#squote
actually there is also a phone number macro in the same webpage
for providing area code if missing (US).

If not familiar with macro see top of that page in yellow box.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lisa" wrote in message ...
My phone number list does not contain a 1 for long distance. I need to
reformat the cell to include a one or my fax machine cannot process the faxes