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.


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569094