How do I format to telephone number

  • Thread starter Stan in South Africa
  • Start date
S

Stan in South Africa

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

Peo Sjoblom

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
 
J

James Silverton

Peo wrote on Mon, 10 Nov 2008 09:29:59 -0800:
000 000 0000
Click to expand...
assuming the number of digits are constant
Click to expand...
any other way would require an event macro
Click to expand...

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
 
Top