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!