View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] emkramer@gmail.com is offline
external usenet poster
 
Posts: 2
Default Find and Replace ROUNDUP(stuff, 0)

I have several hundred cells with =ROUNDUP(formulas, 0). I want to
erase the ROUNDUP( ,0), but don't know how to use find and replace on
this. I can't do it in two steps, because then Excel doesn't like the
resulting formula after deleting either ROUNDUP( or ,0). Is there a
simple way to turn off formulas? Or another way around this problem?

Earl