mail merge from excel to word format issues?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Chaves - 04 Oct 2004 18:49 GMT

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?

Reply to this Message

Richard O. Neville - 04 Oct 2004 19:34 GMT

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.

> 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?

Reply to this Message

Doug Robbins - 05 Oct 2004 00:35 GMT

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

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

Signature

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

Reply to this Message

Darlene - 05 Oct 2004 22:43 GMT

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

> 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?

Reply to this Message