Used to format spread report cells using scientific or significant digit rounding.   Spread uses "normal" rounding by default.  This form can be used to override the default.

USING:

Select the type of rounding (Scientific or Significant Digit), set the decimal places/significant digits and click .  The selected cells will be formatted using the SROUND (Scientific Rounding), SFR (Significant Figure Rounding), or SFRZ (Sgnificant Figure Rounding including MDL Symbol) functions as specfied.

FIELDS:

Scientific Rounding To: Check this box to perform scientific rounding on the selected cells to the number of decimal places specified.  Uses the SROUNDfunction.

Significant Digits:  Check this box to perform significant digit (figure) rounding on the selected cells to the number of significant digits specfied.  Uses the SFR or SFRZ function.

See Also: Round - Spread Function for Normal Rounding