Rounding merged figures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 15 Dec 2005 14:20 GMT

Hi

i am trying to merge some formula results from excel into word. I have
rounded the formula result in excel to two decimal places (using the
=Round(**,2)) but when i merge the data accros to word it puts all the
decimal places back.
I then tried copying the resuls into another cell (using paste special) and
merging that field but i got the same result.

I am using word2003 to do this.

I have just tried the same thing on word2000 and i get the results i need,
but i need to get it working in word 2003 - has any body got any ideas

thanks

Signature

Cheers

Reply to this Message

Graham Mayor - 16 Dec 2005 07:42 GMT

You need to apply a formattind switch in Word (which now ignores formatting
from the data file)
Thus {Mergefield fieldname \# ",0.00"}
see http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> Hi
>
[quoted text clipped - 12 lines]
>
> thanks

Reply to this Message