funky data from xls into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DanJfromOK - 24 Feb 2004 17:46 GMT

Using Office XP: I have an xls spreadsheet that includes a column of numbers formatted with 2 decimals. When I perform the mail merge into a Word document, the field displays "umpteen" decimals on some records, yet truncates the decimal for whole numbers. Ex: I've seen 10567.88 and 10000 and 67890.00000000001

I've found a bit of a workaround by saving the .xls as a .txt then merging, but I lose some of the formatting

I know this can't be right! Any ideas? Thanks!

Reply to this Message

Peter Jamieson - 24 Feb 2004 17:55 GMT

In Word, use e.g.

{ MERGEFIELD mynumber \#"0.00" }

instead of

{ MERGEFIELD mynumber }

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Using Office XP: I have an xls spreadsheet that includes a column of numbers formatted with 2 decimals. When I perform the mail merge into a

Word document, the field displays "umpteen" decimals on some records, yet
truncates the decimal for whole numbers. Ex: I've seen 10567.88 and
10000 and 67890.000000000019

> I've found a bit of a workaround by saving the .xls as a .txt then merging, but I lose some of the formatting.
>
> I know this can't be right! Any ideas? Thanks!

Reply to this Message

Graham Mayor - 25 Feb 2004 05:50 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Using Office XP: I have an xls spreadsheet that includes a column of
> numbers formatted with 2 decimals. When I perform the mail merge
[quoted text clipped - 6 lines]
>
> I know this can't be right! Any ideas? Thanks!

Reply to this Message