Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formating a Merge Field

1 view
Skip to first unread message

dch3

unread,
Jan 26, 2007, 9:35:01 AM1/26/07
to
How can I setup a merge field so that the result appears in a specific
format? I need to do a mail merge using an Excel spreadsheet as the source,
however the telephone numbers are not formated as such (eg 4079947953). For
the merge, I need them to appear formated as phone numbers.

Graham Mayor

unread,
Jan 26, 2007, 10:24:00 AM1/26/07
to
You need a numeric formatting switch - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

joshnm2020

unread,
Mar 23, 2007, 3:01:03 PM3/23/07
to
My phone numbers as coming in from a access database and are in text fields.
Do I need to change them to number fields?
--
.

Graham Mayor

unread,
Mar 24, 2007, 2:33:51 AM3/24/07
to
That rather depends on the result you get when you enter the field without a
switch. If it is a number then no.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

joshnm2020 wrote:
> My phone numbers as coming in from a access database and are in text
> fields. Do I need to change them to number fields?
>

0 new messages