Edit merged excel data

G

Guest

Using Excel and Word 2002, Excel cells formatted in currency with 2 decimal
places merge into Word displaying 14 decimal places. How can I truncate the
14 to 2?
 
T

TF

Dick

An alternative is to change the behaviour in Excel for the SS you are using.
By Default, Excel only displays the number of decimal place you set (2 by
default): however, underneath it keeps all decimal places for accuracy.
Under Tools, Options, Calculation tab, you can check the Precision as
Displayed option. This will export as seen. However, if this is a complex
SS, checking this option may produce inaccurate results.

--
Terry Farrell - Word MVP
http://word.mvps.org/

: Using Excel and Word 2002, Excel cells formatted in currency with 2
decimal
: places merge into Word displaying 14 decimal places. How can I truncate
the
: 14 to 2?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge from Excel 1
Formatting for Currency 1
numerals in a mail merge 1
Using Excel as data for mail merge... 1
How do I truncate decimal places on a merged field? 1
Access stripping decimal places in query 1
Currency from Excel isn't merging into a Word document properly 1
Dollar amounts aren't merging from Excel into a Word document... 3

Top