Posted to microsoft.public.excel.newusers

Kennel slave Kennel slave is offline

external usenet poster

Posts: 2

Telephone Numbers

How do I format an entire column to automatically convert the number:
1236785555 to appear (123) 678-5555?

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
formula for telephone numbers.	biffula	Excel Discussion (Misc queries)	6	November 2nd 07 08:56 PM
converting telephone numbers to csv format!	Rebecca Potter	Excel Discussion (Misc queries)	3	August 22nd 07 11:48 AM
Looking up Telephone Numbers	Peterp	Excel Discussion (Misc queries)	3	March 19th 07 04:43 PM
Can I format telephone numbers?	SouthAfricanStan	Excel Worksheet Functions	3	August 24th 06 08:14 PM
how do i format telephone numbers	Vin	Excel Discussion (Misc queries)	1	May 30th 05 02:46 AM

All times are GMT +1. The time now is 10:46 AM.

About Us

"It's about Microsoft Excel"