View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GusDubs GusDubs is offline
external usenet poster
 
Posts: 2
Default How do I replace forumulas with the round function in one go

I am constantly working on spreadsheets and then realise I wish I had entered
the "round" function at the start. Instinctively I thought of Ctrl+H to
replace but can't figure out how you would put a ,0) at the end.
Also considered a macro with typing - F2, Home, =Round(,End, ,0) - but dont
know how to get this to work over a large range of formulas.
Any help would be appreciated