Excel's conditions ignored by Word in Mail-merge
I'm surprised that ROUND and Paste Special/ Values didn't do the trick, but
try =TEXT(A2,"0.00").
Another option is to use field formatting codes within Word.
--
David Biddulph
"dindigul" wrote in message
...
I have numbers in cells like 3054.30, 2997.48 etc. that need to be brought
into Word via mailmerge. However, in Word docs the values change to
3054.299999 & 2997.477777 ... I tried using the =ROUND() function it did
not have any effect, then I tried using Paste Special, Values ... still no
use. Why is this happening & what could be done to keep the values as
shown? Thanks
|