Formatting phone numbers

[Anonymous]

I have a spreadsheet that has a column for phone number.
The data is stored as a number (ex. 6519999999) but I
need to insert this field in a mail merge document in the
format (651)999-9999.

I know I can change how the cells are DISPLAYED in the
spreadsheet but can I easily change the data?

 

[Frank Kabel]

Hi
try the following formula in the adjacent column:
=TEXT(A1,"(000)000-0000")

 

[JE McGimpsey]

Assuming you're doing the mail merge to Word, I'd leave the numbers as
is, and format them in Word:

{MERGEFIELD phone_number \# "(000)000'-'0000"}

 

[JudithJubilee]

It's a bit long but you could use:

=CONCATENATE("(",LEFT(A1,3),")",MID(A1,4,3),"-",RIGHT(A1,4))

Hope this helps

Judit

 

[Guest]

Thanks Frank! That's exactly what I needed!

-----Original Message-----
Hi
try the following formula in the adjacent column:
=TEXT(A1,"(000)000-0000")

--
Regards
Frank Kabel
Frankfurt, Germany

.