Merged Excel column has nine decimal places in Word

[Circe]

I am merging an Excel file with a Word doc. The Excel
file contains a column of numbers with 2 decimal places,
formatted as such. When performing the merge, the data is
presented in Word with NINE decimal places. Is there any
way to format the Word generated data with 2 decimal
places only?

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Circe,

You don't mention the version of Word involved, but I'm
guessing it's 2002 or 2003. You'll find information about the
problem in the Word 2002 section of my website's mail merge
FAQ.

I am merging an Excel file with a Word doc. The Excel
file contains a column of numbers with 2 decimal places,
formatted as such. When performing the merge, the data is
presented in Word with NINE decimal places. Is there any
way to format the Word generated data with 2 decimal
places only?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail