Merging Excel calculations into Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christy Skinner - 23 Apr 2008 22:57 GMT

I am trying to merge excel calculations into a word document but the numbers
don't have commas seperating the thousands from the hundreds and some of them
show the number to the inth degree rather than rounding it to two decimals.
My formula show the round function and the excel worksheet shows the rounded
numbers. Why does Word show something completely different. Who decided to
fix something that wasn't broken. Merging Excel into Word used to be soooooo
easy.

Christy Skinner

Reply to this Message

Rich/rerat - 23 Apr 2008 23:32 GMT

Christy Skinner,
Add the following switch after you Toggle your Mergefield Amount:

{mergefield amount \# ",0.00;(,0.00)"}

This Should solve both your problems in the Word document.

Signature

Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

I am trying to merge excel calculations into a word document but the numbers
don't have commas seperating the thousands from the hundreds and some of
them
show the number to the inth degree rather than rounding it to two decimals.
My formula show the round function and the excel worksheet shows the rounded
numbers. Why does Word show something completely different. Who decided to
fix something that wasn't broken. Merging Excel into Word used to be
soooooo
easy.

Christy Skinner

Reply to this Message