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 |
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 |