Posted to microsoft.public.excel.programming

Yossy

external usenet poster

Posts: 127

Phone book formatting

please does anyone have any idea how i can format phone no. I want to achieve
this format (xxx) xxx-xxxx. i used this formula
="("&LEFT(G14,3)&")"&MID(G14,4,3)&"-"&RIGHT(G14,4) and because some of my
phone no are in diferent format it didnt give me the right format.
E.G Date I have Format I want Format I get using the formula above
xxx.xxx.xxxx (xxx) xxx-xxxx (xxx) .xx-xxxx
(xxx) xxx-xxxx (xxx) xxx-xxxx ((xx)x) -xxxx

All help appreciated. thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Phone book formatting	Jim Berglund[_2_]	Excel Programming	10	April 15th 08 10:15 PM
Formatting phone numbers	LMR	Excel Discussion (Misc queries)	5	March 4th 08 08:46 PM
Phone Formatting	Jim	Excel Discussion (Misc queries)	9	July 14th 07 05:38 AM
Phone book problem	Padraigglynn	Excel Worksheet Functions	3	March 11th 07 03:59 PM
Phone Number Formatting	Brant Nyman	Excel Discussion (Misc queries)	5	August 25th 05 06:56 PM

All times are GMT +1. The time now is 12:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us