View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
fak119
 
Posts: n/a
Default Rounding-Formulas

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?