How do I format to telephone number
 

Office 2007, Xp Pro
I have cells with text format, ie 0117401342
How do I format to 011 740 1342?

How do I format to telephone number
 

With custom format: 000 000 0000
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Stan in South Africa" <me@there wrote in message
...
Office 2007, Xp Pro
I have cells with text format, ie 0117401342
How do I format to 011 740 1342?

How do I format to telephone number
 

Not possible to customize formatting for text. If they were numbers you can
use


000 000 0000

assuming the number of digits are constant


any other way would require an event macro

--


Regards,


Peo Sjoblom

"Stan in South Africa" <me@there wrote in message
...
Office 2007, Xp Pro
I have cells with text format, ie 0117401342
How do I format to 011 740 1342?

How do I format to telephone number
 

With data in A1
=TEXT(A1,"000 000 0000")
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Stan in South Africa" wrote:

Office 2007, Xp Pro
I have cells with text format, ie 0117401342
How do I format to 011 740 1342?

How do I format to telephone number
 

Peo wrote on Mon, 10 Nov 2008 09:29:59 -0800:

000 000 0000

assuming the number of digits are constant

any other way would require an event macro

Of course, if you are willing to have the text numbers in A and another
column, say B, formatted 000 000 0000, you could make, say,
B1=VALUE(A1).

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not