Merging from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kwasylik - 13 Feb 2004 21:51 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 14 Feb 2004 01:52 GMT

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

\# "#,##0.00"

Signature

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

>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
[quoted text clipped - 4 lines]
>
> Is there a way around this?

Reply to this Message

Graham Mayor - 14 Feb 2004 06:35 GMT

> 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
[quoted text clipped - 5 lines]
>
> Is there a way around this?

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<

Reply to this Message