mail merge and data source help

[Guest]

I have a word table set up for mail merge. The data source is an excel
database. One of the columns in excel has numbers with a decimal place
(example: ##.###). When it is merged into word with the mail merge field,
the number comes up (##.###########) even though in excel the column is
formatted correctly. How can I get it to only show 3 numbers after the
decimal. I cannot figure out what is going on because I would think it would
only show what is in the column of excel. Help, and thanks

 

[Graham Mayor]

The formatting in Excel is irrelevant and ignored. You need to set the
formatting on the Word field - see
http://www.gmayor.com/formatting_word_fields.htm

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

My web site www.gmayor.com

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