Fromating numbers in Mail merge

[rd]

Hi,

How do i format numbers that coming from a merged Excel file? i want to have
comma separators, like 10,000.00 instead of 10000.

thanks in advance.

RD

 

[Graham Mayor]

Use a formatting switch on the field thus
{Mergefield Fieldname \# ",0.00"}
See http://www.gmayor.com/formatting_word_fields.htm

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Hi rd,

Add the \# switch to your field. For details, check the Word help.

Good luck,
Cooz

 

[Suzanne S. Barnhill]

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[rd]

WOW, thanks.

RD

Use a formatting switch on the field thus
{Mergefield Fieldname \# ",0.00"}
See http://www.gmayor.com/formatting_word_fields.htm

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[rd]

Thanks Cooz.

RD

Hi rd,

Add the \# switch to your field. For details, check the Word help.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in
via
the Microsoft site, please click Yes to "Did this post answer the
question?".
Thanks.

 

[rd]

Thanks Suzanne.

RD

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.