See
http://www.gmayor.com/formatting_word_fields.htm
or
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
McFox wrote:
I am attempting to merge a percentage field in Excel into a Word mail
merge. However the format of the field is coming across in scientific
notation format, rather than as a simple percentage; thus -0.8%
appears as -8.0239339948077817E-3.
I have checked the format of the cell in Excel and it is listed as
'Percentage'.
Bizarrely, another spreadsheet with similar data and same formatting
of the cell is pulling through the percentage in the correct format!
Anyone out there help me?
Thanks.
McFox