Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel $ merges with multiple numbers after decimal in Word. Why?
When I merge an Excel file into a Word document, the dollar amount column
(with a formula) comes across in my Word document with multiple numbers after the decimal point. Is there some special way the Excel column should be formatted? I have tried many ways and am ready to pull my hair out! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel $ merges with multiple numbers after decimal in Word. Why?
Hi Bonnie,
You can control this by adding a numeric picture switch to your mergefield. If you select the existing mergefield and press Shift-F9, you should see something like: {MERGEFIELD ExcelValue} Change this to: {MERGEFIELD ExcelValue \# $,0.00} or something similar, then run your merge. See Word's help file for more information of field formatting. Cheers "BonnieJean" wrote in message ... When I merge an Excel file into a Word document, the dollar amount column (with a formula) comes across in my Word document with multiple numbers after the decimal point. Is there some special way the Excel column should be formatted? I have tried many ways and am ready to pull my hair out! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reveal codes in a word document | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
hard space between words. | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout |