Help with a document merge to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Capt_Trips - 18 Apr 2006 13:07 GMT

I have a spreadsheet for our customers...some cells are Percentages an
sone are dollar amounts. When I merge the document to my Word file
some of the Percents come through like this "2.5000000000000001E-3
(this should read .25%)...most of my dollar amounts are coming throug
without the comma and the dollar sign. I have tried to format the cell
(and columns) appropriately but it still comes out like this. An
thoughts?

John

PS sorry for the double pos

--
Capt_Trips

Reply to this Message

macropod - 18 Apr 2006 23:37 GMT

Hi Capt_Trips,

You could use a DDE connection for your merge, which will preserve Excel's
formatting, or you could use a formula field within Word to convert the
results to the correct format.

For the latter:
. select your mergefield, which will look something like «Percent»
. press Ctrl-F9 to wrap another field around it, thus - { «Percent» }
. edit the field so that you get {=«Percent»/100 \# 0.00%}
. press F9 to update the field
. run your mailmerge

Cheers

> I have a spreadsheet for our customers...some cells are Percentages and
> sone are dollar amounts. When I merge the document to my Word file,
[quoted text clipped - 7 lines]
>
> PS sorry for the double post

Reply to this Message