How do I fix Mail Merge numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura - 22 Jun 2005 16:59 GMT

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?

Reply to this Message

Anne Troy - 22 Jun 2005 17:24 GMT

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?

Reply to this Message

Graham Mayor - 23 Jun 2005 06:17 GMT

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)

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

Reply to this Message