Merging from Excel

[kwasylik]

I am merging data from Excel into Word. The numerical data in Excel is formatted to 2 decimals but when I merge them into word, they change into 14 decimal places. For example 687.76 turns into 687.7599999999999999

The data in Excel is not a calculation field and is formatted for 2 decimal places

Is there a way around this

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Press Alt +F9 to toggle on the field codes and inside the closing } insert
the following numeric formatting switch

\# "#,##0.00"

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

 

[Graham Mayor]

I am merging data from Excel into Word. The numerical data in Excel
is formatted to 2 decimals but when I merge them into word, they
change into 14 decimal places. For example 687.76 turns into
687.7599999999999999.

The data in Excel is not a calculation field and is formatted for 2
decimal places.

Is there a way around this?

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>