View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fak119
 
Posts: n/a
Default Late Rounding of Formula

Is there (or can there be) a macro or a function that changes a formula like

=C1*$R4 in =round(C1*$R4,0) etc.

I have many spreadsheets with hundreds of formulas on each sheet that need
to be rounded. I would have to change individually every single formula. Is
there an easier way? It could be the "Replace" function if it worked with the
possibility to change the formula on both ends at the same time such as
(example from above):

Replace: =
With: =round( [####=Joker] ,0)