Hi,


The format you want is (###) ###-####.

However if your numbers has spaces it will read as text. You could use a extra column with this formula to remove one space

=SUBSTITUTE(A1," ","",1)

Drag down and covert to number then custom format as above.

If this doen't help a sample of the data would be useful

VBA Noob.