How do I get the rounded values from excel to a word document.

G

Guest

When I imported an excell spreadsheet data into a word document, the vales in
the currency field were not rounded to two places even though the cells were
formatted to two places. This is using office 2003. I had used this in an
older version and it worked fine.
 
B

Bernard Liengme

Rather format use ROUND(whatever,2)
Formatting does not change the stored value only the displayed value
best wishes
 

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

Excel Stop Excel from displaying rounded values 4
Using Excel values in Word Mail Merge 3
Dollar amounts aren't merging from Excel into a Word document... 3
how to multiply two values and round the result 5
Losing cell formatting as a result of a mail merge 5
how do i add rounded numbers? 4
Value Rounded when copied from another cell 3
How do I get Access to append the exact amount with decimals? 2

Top