Word/Excel 2007 Problem with Number Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda - 27 Mar 2008 15:29 GMT

I have an Excel 2007 spreadsheet and am trying to merge with a Word 2007
document. The merge is easy EXCEPT that my numbers that are formatted as
rounded to the nearest whole number in Excel are coming over as numbers with
10 and 11 numbers after the decimal point in Word. What do I need to do??
I'm not a tech guru and many of the solutions I've found on-line exceed my
technical abilities. Does anyone have a solution that is fairly easy to
understand?
Thank you!

Reply to this Message

Graham Mayor - 27 Mar 2008 15:40 GMT

You need a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm
In simplistic terms
Press ALT+F9. This will change the display from <<Fieldname>> to {Mergefield
Fieldname}
add the switch inside the brackets eg {Mergefield Fieldname \# ",0.00"}
Press F9 to update and Alt+F9 to re-display the fields.

Signature

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

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

> I have an Excel 2007 spreadsheet and am trying to merge with a Word
> 2007 document. The merge is easy EXCEPT that my numbers that are
[quoted text clipped - 4 lines]
> anyone have a solution that is fairly easy to understand?
> Thank you!

Reply to this Message

Rate this thread: