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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Rather format use ROUND(whatever,2)
Formatting does not change the stored value only the displayed value
best wishes
 
Back
Top