Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Phone number
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Lisa
Use another column and type in ="1"&A2 Then copy down. (Presumes number in columnA) Now copy the 'new' numbers and editcopy, then Editpaste 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 HIS "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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phone Number Formats | Excel Discussion (Misc queries) | |||
How do I delete the "=" from a cell to give me the phone number I. | Excel Discussion (Misc queries) | |||
Alpha Phrase To Phone Number Calculator in excel | Excel Discussion (Misc queries) | |||
Phone Dialer | Excel Discussion (Misc queries) | |||
Concatenate two halves of a phone number | Excel Worksheet Functions |