Phone number

[Lisa]

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

[David McRitchie]

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" <Lisa@discussions.microsoft.com> wrote in message news:B3524B9B-56FB-4725-B20B-A37D3E0B9AFB@microsoft.com...
> 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

[Nick Hodge]

Lisa

Use another column and type in

="1"&A2

Then copy down. (Presumes number in columnA)

Now copy the 'new' numbers and edit>copy, then Edit>paste special+values
over the old data and delete the column with the formulas which are now not
needed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"Lisa" <Lisa@discussions.microsoft.com> wrote in message
news:B3524B9B-56FB-4725-B20B-A37D3E0B9AFB@microsoft.com...
> 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

[Gary's Student]

If your phone numbers look like 609-555-1212 in cell A1, then use the formula:

="1-" & A1 in another cell
--
Gary's Student


"Lisa" wrote:

> 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