Microsoft KB Archive/124423

= Works: How to Truncate Numbers in Works Without Rounding =

Article ID: 124423

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q124423



SUMMARY
To truncate numbers without rounding in a Works for Windows spreadsheet or database, use one of the following formulas

Spreadsheet: =INT( * 10^)/10^

Database: =INT( * 10^)/10^

where , , or  is the number to be truncated.  is the desired number of places to the right of the decimal point.

NOTE: The caret ^ (SHIFT+6) is the exponential operator.

EXAMPLE
To truncate the number 12.34567 to two digits in a spreadsheet, do the following.


 * 1) Create a new Spreadsheet.
 * 2) In cell A1, enter the number 12.34567.
 * 3) In cell B1, enter the formula =INT(A1*10^2)/10^2.

The value in B1 is 12.34. Note that the value did not round to 12.35.



MORE INFORMATION
Works for Windows has a Round function that will round a number to a specific number of digits. To truncate the number without rounding, the formula above must be used. For example, rounding the number 123.456 to two significant digits equals 123.46, while truncating equals 123.45. Truncating can be useful when you want to avoid errors in calculations caused by rounding.

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto w_works round significant formula shorten

Keywords: kbhowto kbinfo KB124423

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.