Hi Sean,

You could use Tools|Options and check 'precision as displayed'. Although the
cells will still contain the decimal values, you won't see them and they'll
be rounded off in any calculations. No need to select anything.

Cheers


"Sean Lambertz" wrote in message
...
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?