Format Phone Numbers

[D Oliver]

I am having problems with merge data (phone numbers)from
Access displaying straight numbers rather than 555-6459.
I can get the area code in parenthesis but cannot get
the "-" to display. HELP!!!

 

[Peter Jamieson]

Try putting single quotes around the "-"s, e.g.

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