How can I...

round up or down a a price to the nearest dollar and leave no decimal
points? I have treid formatting the cell so it doesn't show the cents but
the value still exists as a number in excel. I want to show just the whole
dollar amount with no change but I need to do it in one sweeping change to a
huge price list. How can I do that while highlighting the work???

Oh yeah, I can't show any formulas later.

Any ideas?