Rounding numbers

I am merging from a dbf file that has a field were the dollar amount is
carried out 9 places because of sales taxes. Example $185.050000001.
How can I make Word2003 change this to regular dollars and cents? To
round up to two places.

Also can you caculate in Word mail merge? Example: Balance field -
credits field times sales tax?
Thanks


---
Message posted from http://www.ExcelForum.com/

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"GTNET " wrote in message
...
I am merging from a dbf file that has a field were the dollar amount is
carried out 9 places because of sales taxes. Example $185.050000001.
How can I make Word2003 change this to regular dollars and cents? To
round up to two places.

Also can you caculate in Word mail merge? Example: Balance field -
credits field times sales tax?
Thanks


---
Message posted from http://www.ExcelForum.com/

I round by right clicking on the field, then toggling used the toggle field
code command. Then follow the instructions on
http://www.gmayor.com/formatting_word_fields.htm

When you click update, you get the original field name back

"GTNET " wrote:

I am merging from a dbf file that has a field were the dollar amount is
carried out 9 places because of sales taxes. Example $185.050000001.
How can I make Word2003 change this to regular dollars and cents? To
round up to two places.

Also can you caculate in Word mail merge? Example: Balance field -
credits field times sales tax?
Thanks


---
Message posted from http://www.ExcelForum.com/