Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
telephone number format change in Excel | Excel Worksheet Functions | |||
custom telephone number format | Excel Discussion (Misc queries) | |||
Can I format telephone numbers? | Excel Worksheet Functions | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
Telephone number format | Excel Discussion (Misc queries) |