| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
phone number formatting for dummies
I am using Excel 2003 and I am trying to format my phone numbers to all be
like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
"("###")" ###-####
Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right
hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! -- lynetteb "Peter T" wrote: "("###")" ###-#### Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
--Select the cells
--Right clickFormat CellsFrom 'Numer' tab list select Custom --In the type text box enter as per Peters suggestion If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! -- lynetteb "Peter T" wrote: "("###")" ###-#### Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
It doesn't change anything it just adds it as a custom format and then my
number stays the same as it was originally entered, with no ()'s around the area code. -- lynetteb "Jacob Skaria" wrote: --Select the cells --Right clickFormat CellsFrom 'Numer' tab list select Custom --In the type text box enter as per Peters suggestion If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! -- lynetteb "Peter T" wrote: "("###")" ###-#### Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
Typo in Peter's suggestion.
He meant CTRL + 1 Gord Dibben MS Excel MVP On Thu, 6 Aug 2009 10:00:02 -0700, lynetteb_308 wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
It still does not give me the ( ) around the area code.
-- lynetteb "Gord Dibben" wrote: Typo in Peter's suggestion. He meant CTRL + 1 Gord Dibben MS Excel MVP On Thu, 6 Aug 2009 10:00:02 -0700, lynetteb_308 wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
Try this in a new workbook
--Enter the below 10 digit number in A1 1234567890 --Select A1. Right clickFormat CellsFrom 'Number' tab list select 'Custom' --In the 'Type:' text box enter the below string ('General' will be the default; replace that with the below string) "("###")" ###-#### Test and feedback...If it works Select the entrire column and format and try entering new numbers... If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: It doesn't change anything it just adds it as a custom format and then my number stays the same as it was originally entered, with no ()'s around the area code. -- lynetteb "Jacob Skaria" wrote: --Select the cells --Right clickFormat CellsFrom 'Numer' tab list select Custom --In the type text box enter as per Peters suggestion If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! -- lynetteb "Peter T" wrote: "("###")" ###-#### Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
ok that works!
thank you all very much for putting up with the slow learner! -- lynetteb "Jacob Skaria" wrote: Try this in a new workbook --Enter the below 10 digit number in A1 1234567890 --Select A1. Right clickFormat CellsFrom 'Number' tab list select 'Custom' --In the 'Type:' text box enter the below string ('General' will be the default; replace that with the below string) "("###")" ###-#### Test and feedback...If it works Select the entrire column and format and try entering new numbers... If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: It doesn't change anything it just adds it as a custom format and then my number stays the same as it was originally entered, with no ()'s around the area code. -- lynetteb "Jacob Skaria" wrote: --Select the cells --Right clickFormat CellsFrom 'Numer' tab list select Custom --In the type text box enter as per Peters suggestion If this post helps click Yes --------------- Jacob Skaria "lynetteb_308" wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! -- lynetteb "Peter T" wrote: "("###")" ###-#### Select the cells to want to format and press Ctrl-F1 Custom below 'Type' paste the above Copy the above and paste into the 'Custom' Regards, Peter T "lynetteb_308" wrote in message ... I am using Excel 2003 and I am trying to format my phone numbers to all be like (###) ###-####, from ###-###-####. I have followed some of the other suggestions given in the forum but nothing gives me the () around the area code. Unfortuantley I need very detailed, step-by-step instructions on how to include the () around the area code. Please help! -- lynetteb |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
The currently entered phone numbers are text-entered so Custom format won't
work. Remove the dashes using editreplace. Now custom format or special format as telephone numbers Gord On Thu, 6 Aug 2009 11:27:02 -0700, lynetteb_308 wrote: It still does not give me the ( ) around the area code. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
phone number formatting for dummies
He meant CTRL + 1
Oops! Sorry lynetteb, and thanks Gord Peter T "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Typo in Peter's suggestion. He meant CTRL + 1 Gord Dibben MS Excel MVP On Thu, 6 Aug 2009 10:00:02 -0700, lynetteb_308 wrote: ok, I was able to to Ctrl-F1 and it brought up the clipboard on the right hand screen. But, from there what you are saying doesn't make sense to me. There is nothing that says custom so the rest of what you are telling me to do, means I can't. I really don't know what I am doing and am a little technology challenged so you have to be very specific. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Phone number formatting | Excel Discussion (Misc queries) | |||
| Phone Number formatting | Excel Worksheet Functions | |||
| PHONE NUMBER formatting | Excel Worksheet Functions | |||
| Formatting a Phone Number | Excel Discussion (Misc queries) | |||
| Provide a phone # to help the dummies. | New Users to Excel | |||
Linear Mode
