View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
orangie orangie is offline
external usenet poster
 
Posts: 7
Default how do i add more to a formula without going into each cell?

I have a value in a cell, say A2 =5.62345. And I want to add a formula to
this value in this cell, basically =round(5.62345, 2), but i have 30+ cells
with values and I don't want to go into each cell individually. is there
anyway to avoid this?

Thanks!