Format Phone Numbers

D

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!!!
 
P

Peter Jamieson

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

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