On Sun, 17 Jul 2005 06:39:01 -0700, "renold1958"
wrote:
Have a spreadsheet....one column keeps coming up with #DIV/0!.........I know
reasons as of to why, etc etc............is there anyway have the #DIV/0!
values disappear from a column?

If column A has a price and column B has a weight, and you're dividing
these to get the price per pound in column C:

=IF(B1="0",something,A1/B1)

Replace something with whatever you want displayed in lieu of the
division by zero error. So if you want it to be blank, put: ""

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner