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!