Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Pre-set Query Conditions that cannot be changed | Mailmerge | |||
WP merge file to Word | Tables | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help |