funky data from xls into word

[DanJfromOK]

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!

 

[Peter Jamieson]

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.

 

[Graham Mayor]

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

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

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