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

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

--

Graham Mayor - Word MVP

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


Joe wrote:
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