mail merge from excel to word format issues?

[Michael Chaves]

Hello-

I am dong a mailmerge from Excel to Word. The merge contains percentacges
such as 6.125% . When I try to merge it shows up as "6.1249999999999999E-2".
This has only happened since my change to 2003. Any ideas?

 

[Richard O. Neville]

In the Excel sheet, go to Tools-Options, Calculation tab, and check
"Precision as displayed." You will lose some 15-decimal point accuracy but
this should solve the problem. You will have to save and close Excel in
order for it to work.

 

[Doug Robbins]

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

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Darlene]

You can try this: edit merge field and type in the follow {Mergefield
percentage \#"00%"} I was having the same problem and this solved the
situation