Rather format use ROUND(whatever,2)
Formatting does not change the stored value only the displayed value
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"New York Grange" <New York wrote in
message ...
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.