If the cells are formatted as you wish them (i.e. displaying numbers
with no decimal places, then you can click on Tools | Options |
Calculation tab, then check Precision as Displayed. Excel will give
you a warning, but if you click OK then those numbers will be changed
to match the display. It might be a good idea to change the setting
back, and to use File | Save As to give the file a different name, so
that you can always get back to the original if you need to.

Hope this helps.

Pete