Hi Corey,

See David McRitchie's TrimAll page at:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall



---
Regards,
Norman


"Corey" wrote in message
...
Right Click the Cell and,
Format Cells - Number - Take the Decimal places away.
This will round to next whole number.

Corey....