Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many decimal places
Hello--
I've got a sizable Excel worksheet that's the source document for a complex Word merge document. The Excel cells are formatted as dollar amounts with two decimal places. But when the merge happens, some of the resulting values in the Word document show with 0-12 decimal places. Most of the affected fields are not calculations, but are merely repositories for values that were input with two decimal places. In Excel, I've tried the Tools/Options/Calculations/Precision as Displayed, but that didn't resolve the problem. The resulting merge is about 400 pages long, and last year we manually truncated the offending cells, an activity we'd prefer not to repeat. Any ideas would be greatly appreciated--thanks! L |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many decimal places
Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. lmk wrote: Hello-- I've got a sizable Excel worksheet that's the source document for a complex Word merge document. The Excel cells are formatted as dollar amounts with two decimal places. But when the merge happens, some of the resulting values in the Word document show with 0-12 decimal places. Most of the affected fields are not calculations, but are merely repositories for values that were input with two decimal places. In Excel, I've tried the Tools/Options/Calculations/Precision as Displayed, but that didn't resolve the problem. The resulting merge is about 400 pages long, and last year we manually truncated the offending cells, an activity we'd prefer not to repeat. Any ideas would be greatly appreciated--thanks! L -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many decimal places
It worked! Thank you very much! I thought that the Answer Box
solution wouldn't work with Word 2003, so I tried the field codes...only to find that my testing of the DDE option hadn't gone far enough. In any event, I won't be afraid to try field coding again either. Thanks again--you've saved us countless hours!! L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Places | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Max decimal places | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
VBA decimal places | Excel Programming |