View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Correcting Multiple Div#0s

Hi,
unfortunately you can't you need to rewrite your formula a suggested by Eva

"ANTBOH" wrote:

Hi guys

I have a big column of formulae that contains lots of div#0s. All formula
are different. Is there anyway I can remove the div#0s (to simply leave a 0
or a blank) without having to rewrite each formula?

Thanks for the help!

ANT