How to format a phone number in Excel
You may try a formula like this:
=TEXT(A1,"(###) ###-####")
Hope this helps,
Miguel.
"tfanatik" wrote:
I can't get a column of numbers, 9999999999, to format as a phone number,
(999) 999-9999. I've tried phone number format, as well as what I found in
this discussion group and nothing has worked. Any new suggestions?
|