[Amanda]

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!

[Graham Mayor]

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.

--

Graham Mayor - Word MVP

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



Amanda wrote:
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!