Help with a document merge to Word

[Capt_Trips]

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

 

[macropod]

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