Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel 2000. I have a column of number that import as text that I would like
to format as phone numbers. Ex: 9999999999 should appear as (999) 999-9999. When I apply the PN format nothing happens..I'm guessing because it is text. Any suggestions? Thx! |
#2
![]() |
|||
|
|||
![]()
to you want the final result to be text or numeric.
if numeric. in a blank cell enter 1 select it and copy select the column to telphone numbers and paste special multiply. If you formated the number as telephone they should now show up that way. "longisland" wrote: Excel 2000. I have a column of number that import as text that I would like to format as phone numbers. Ex: 9999999999 should appear as (999) 999-9999. When I apply the PN format nothing happens..I'm guessing because it is text. Any suggestions? Thx! |
#3
![]() |
|||
|
|||
![]()
Thanks for your assistance!
"bj" wrote: to you want the final result to be text or numeric. if numeric. in a blank cell enter 1 select it and copy select the column to telphone numbers and paste special multiply. If you formated the number as telephone they should now show up that way. "longisland" wrote: Excel 2000. I have a column of number that import as text that I would like to format as phone numbers. Ex: 9999999999 should appear as (999) 999-9999. When I apply the PN format nothing happens..I'm guessing because it is text. Any suggestions? Thx! |
#4
![]() |
|||
|
|||
![]()
Select your column and format as Phone Number.
Then......DataText to ColumnsNextNextColumn Data FormatGeneralFinish. Gord Dibben Excel MVP On Tue, 20 Sep 2005 13:21:03 -0700, "longisland" wrote: Excel 2000. I have a column of number that import as text that I would like to format as phone numbers. Ex: 9999999999 should appear as (999) 999-9999. When I apply the PN format nothing happens..I'm guessing because it is text. Any suggestions? Thx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) |