#1   Report Post  
DR
 
Posts: n/a
Default Rounding

1. I have forgotten how to round formula results in a Word (2000) table,
and there don't seem to be any examples in help. I want, e.g., to
display a formula result that would be 1030 as having been rounded to
the nearest 100, or 1000.

2. I'd also like to have the table not display the light gray borders,
where no actual printing borders are specified.

Thanks.
  #2   Report Post  
Greg
 
Posts: n/a
Default

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

  #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.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
If field calculation Dawn Rhoads Microsoft Word Help 13 December 10th 04 08:27 PM
Rounding Down in Word macropod Tables 0 October 26th 04 10:22 AM


All times are GMT +1. The time now is 06:54 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"