Thread: Rounding
View Single Post
  #3   Report Post  
DR
 
Posts: n/a
Default

Greg wrote:
DR,

Try {=round(X,-2)} where X is the formula (e.g., {=round(1030,-2)}
would round to 1000 {=round(1051,-2)} would round to 1100
To hide the gridline, press TableHide Gridlines

Thanks. I'm always conflicted about whether to do things in Word or
Excel when they have a lot of words and a lot of numbers. Inserting an
Excel object seems to have some problems in the implementation for 2000.