Any MS Excel Guru's? - Help Please
Hi
I've just spent about three weeks building a MS Excel spreadsheet that calculates our retail price lists for our business (lots of work!).
I've pretty much finished it, but I now realise that perhaps I should have rounded all retail prices to the nearest whole figure (ie. £70.31 would round to £70.00).
Is there an easy way to globally round all the prices in one go by just selecting a column of cells, or do I have to use the 'round' function on each individual cell by individually editing it?
Please tell me there's an easy way to do it
Cheers
Jem
Quote: "There is a theory which states that if ever, for any reason, anyone discovers what exactly the Universe is for and why it is here it will instantly disappear and be replaced by something even more bizarre and inexplicable. There is another that states that this has already happened.”... Douglas Adams 1952 - 2001