Rounding numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GTNET - 16 Nov 2004 19:08 GMT

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

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

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

Reply to this Message

Doug Robbins - 17 Nov 2004 11:07 GMT

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

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

Signature

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

>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.
[quoted text clipped - 7 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Fungus - 17 Nov 2004 16:01 GMT

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

> 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.
[quoted text clipped - 7 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message