if the reason "as of to why, etc etc....." is the fact that - say cell C5 -
is blank the try:

=IF(C5=0,"",B5/C5)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


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