Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format a phone number in Excel
I can't get a column of numbers, 9999999999, to format as a phone number,
(999) 999-9999. I've tried phone number format, as well as what I found in this discussion group and nothing has worked. Any new suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format a phone number in Excel
You may try a formula like this:
=TEXT(A1,"(###) ###-####") Hope this helps, Miguel. "tfanatik" wrote: I can't get a column of numbers, 9999999999, to format as a phone number, (999) 999-9999. I've tried phone number format, as well as what I found in this discussion group and nothing has worked. Any new suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format a phone number in Excel
It seems like your phone "number" is actually numeric text.
Try this: Select the cell(s) Format them to Phone Number <fomat<cells<number tab Category: Special Type: phone number While the cells are still selected... <data<text-to-columnsClick [Finish] Does that help? *********** Regards, Ron XL2002, WinXP "tfanatik" wrote: I can't get a column of numbers, 9999999999, to format as a phone number, (999) 999-9999. I've tried phone number format, as well as what I found in this discussion group and nothing has worked. Any new suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format a phone number in Excel
Most likely 9999999999 is stored in your column as texts not numbers.
First convert them to numbers then use phone number format. To convert to numbers, try this: 1) In any cell type number 1; 2) Press Ctrl+C to copy the cell; 3) Select the whole range which contains the text which you want to convert to numbers; 4) Go to menu: Edit/Paste Special, check Paste - Values, Operation - Multiple. This will multiply all cells by 1 and automatically convert those texts into numbers. -- Best regards, --- Yongjun CHEN www.XLDataSoft.com ================================= "tfanatik" wrote in message ... I can't get a column of numbers, 9999999999, to format as a phone number, (999) 999-9999. I've tried phone number format, as well as what I found in this discussion group and nothing has worked. Any new suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format a phone number in Excel
And yet another way......
="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4) Vaya con Dios, Chuck, CABGx3 "tfanatik" wrote: I can't get a column of numbers, 9999999999, to format as a phone number, (999) 999-9999. I've tried phone number format, as well as what I found in this discussion group and nothing has worked. Any new suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |