View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Inserting MROUND into existing data

I have several columns of data and I need to have them rounded (mround is my
function of choice); but how do I insert the formula into all cells? I tried
mround(relative reference;number) but that invokes a circular reference
error... Where do I go wrong?