Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Capt_Trips
 
Posts: n/a
Default Help with a document merge to Word


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,
some of the Percents come through like this "2.5000000000000001E-3"
(this should read .25%)...most of my dollar amounts are coming through
without the comma and the dollar sign. I have tried to format the cells
(and columns) appropriately but it still comes out like this. Any
thoughts?

John

PS sorry for the double post


--
Capt_Trips
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod
 
Posts: n/a
Default Help with a document merge to Word

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


"Capt_Trips" wrote in message
. ..

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,
some of the Percents come through like this "2.5000000000000001E-3"
(this should read .25%)...most of my dollar amounts are coming through
without the comma and the dollar sign. I have tried to format the cells
(and columns) appropriately but it still comes out like this. Any
thoughts?

John

PS sorry for the double post


--
Capt_Trips



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Pre-set Query Conditions that cannot be changed Charity Event Secretary Mailmerge 4 April 17th 06 05:56 PM
WP merge file to Word sstires Tables 4 February 14th 06 07:26 PM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 05:32 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 07:13 PM


All times are GMT +1. The time now is 08:10 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"