View Single Post
  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

See http://www.gmayor.com/formatting_word_fields.htm

For the former you need

{Mergefield phonefieldname \# "(000) 000'-'0000"}

for the latter you need
{Mergefield zipfieldname \# "00000'-'0000"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Omega411 wrote:
I have a database on Lotus and want to merge phone numbers. The phone
numbers in the database are 10 digits (XXXXXXXXXX) and I want to
merge them so that it shows up (XXX) XXX-XXXX, with parenthasis and a
dash.
Is this possible?
Also I have 9 digit Zip codes with the same problem. I have XXXXXXXXX
in the database, but want to format the merge so that XXXXX-XXXX
shows up with the dash.
Any help is much appreceated.