Gday Excel Gurus ,

When I do my prices I do them in Excel... I have no problems importing the data or formulating the prices.. My problem is when I enter the formua that gives me the final price, I get an error in the cells that should be empty.. I have to go back and manually clear the error from the cells.. just to make it look better i guess.. the error i get is #DIV/0!

My question is how can I either stop this error from displaying or alternatively remove all of them in one hit instead of doing it cell by cell. I have used the find/replace command but it does not recognise the error as even being there.. Any help would be greatly appreciated... it is really only needed to speed things up for me is all, it isnt a huge prob but more of a nuisance

Thanks in advance

__________________
Good luck and good punting

xptdriver@hotmail.com