Re: How do I format text, like Medicare number
- From: "Graham Mayor" <gmayor@xxxxxxxx>
- Date: Fri, 26 May 2006 07:14:18 +0300
You are not going to be able to format the field in Word while the 'A' is
present in the number. Create a new column in the Excel table and separate
the number from the letter, then you can combine the fields to produce the
layout eg
{MergeField MediNumber \# "000'-'00'-'0000"}{Mergefield Suffix}
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Code Doctor wrote:
I have in Excel a text field that contains unformatted Medicare
numbers, ie 123456789A. In a mail merge, using that field, I want the
display to look like 123-45-6789A.
.
- Prev by Date: Re: address bolded when mailmerge from Outlook to Word
- Next by Date: Re: If then else question
- Previous by thread: Re: address bolded when mailmerge from Outlook to Word
- Next by thread: Re: How do I format text, like Medicare number
- Index(es):
Relevant Pages
|
