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?