How do I fix Mail Merge numbers

[Laura]

I am merging an excel spreadsheet with a letter in word. The number column
in excel is coming across to word as 1621.33335899999 instead of 1621.34. I
have tried reformatting the column in excel, to no avail. Any Suggestions?

 

[Anne Troy]

Try this, Laura:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

I am merging an excel spreadsheet with a letter in word. The number column
in excel is coming across to word as 1621.33335899999 instead of 1621.34. I
have tried reformatting the column in excel, to no avail. Any

Suggestions?

 

[Graham Mayor]

You need a formatting switch on the merge field - see
http://www.gmayor.com/formatting_word_fields.htm
In this instance the switch you want is \# ",0.00" (remove the comma if you
don't want the thousands separator)

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>