How do I format incoming data in mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Just For Looks - 06 Apr 2007 19:56 GMT

Excell calculates data to the last decimal place, but I only want the first
few decimal places for my mail merge document. How do I format the data so
that my mail merge document limits the decimal places or includes the
formatting that Excell uses?

Reply to this Message

Graham Mayor - 07 Apr 2007 06:30 GMT

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

Signature

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

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

> Excell calculates data to the last decimal place, but I only want the
> first few decimal places for my mail merge document. How do I format
> the data so that my mail merge document limits the decimal places or
> includes the formatting that Excell uses?

Reply to this Message

Anne Troy - 07 Apr 2007 06:33 GMT

I'm sure this question has been asked and answered a gazillion times 'cause
it's a well-known issue. Did you try a search? Try to do that first to save
yourself some time. :) Here's my article that covers it.
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

> Excell calculates data to the last decimal place, but I only want the
> first
> few decimal places for my mail merge document. How do I format the data
> so
> that my mail merge document limits the decimal places or includes the
> formatting that Excell uses?

Reply to this Message

Rate this thread: