View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default Roundup with paste special

I'd like to roundup the results to a paste special operation. I'm multiplying
100's of cells by, e.g. 0.7458, and this obviously results in an unrounded
number. I then have to manually amend all the cells to round the results.
I'm wondering is there is a means to "past special & roundup" simultaneously?
I use Excel 2003.
Al