View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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