Graham's given you one approach, involving numeric picture switches. Another
approach is to actually round the numbers in Excel, rather than simply
relying on formatting.

Cheers


"merging whole numbers" merging whole
wrote in message ...
Please help!!! When merging numbers that have been averaged in Excel (and
formatted in Excel to 0 spaces), how do I get rid of the decimal places
and
convert to a whole number?

Please help!!! When merging numbers that have been averaged in Excel (and
formatted in Excel to 0 spaces), how do I get rid of the decimal places and
convert to a whole number?

See http://www.gmayor.com/formatting_word_fields.htm
If you cannot work it out from this, post exactly what the field currently
produces when merged and what you expect it to produce.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




merging whole numbers wrote:
Please help!!! When merging numbers that have been averaged in Excel
(and formatted in Excel to 0 spaces), how do I get rid of the decimal
places and convert to a whole number?