Merged Excel column has nine decimal places in Word

  • Thread starter Thread starter Circe
  • Start date Start date
C

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?
 
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
 
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?
Click to expand...

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 :-)
 
Back
Top