Try rounding the data in Excel (unless you are actually paying people in
increments of less than a penny). What you are currently doing is altering
the display while leaving the underlying number untouched.
You can also apply a picture (format) to your merge field. If your hourly
rate in Excel, though, is a calculated field, you do really want to apply
the Round function to your result or you can get spreadsheet calculation
errors that are not apparent.
--
Charles Kenyon
Word New User FAQ & Web Directory:
http://addbalance.com/word
Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
http://addbalance.com/usersguide
See also the MVP FAQ:
http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"Sherry" wrote in message
...
I am doing a mail merge from an Excel document. The
field in the document is an hourly salary amount, so it
is formatted as a number with 2 decimals. When I set up
the merge to Word, however, it shows the field as having
15 decimals. I cannot change the format once it is in
Word. I have tried using several different formats while
it is still in Excel, before the merge, including a
custom format, but no matter how it shows formatted in
Excel, when it is merged into Word the 15 decimal places
appear. Any ideas?
Thanks,
Sherry
Rome, Georgia