Microsoft KB Archive/115951

= Works: Entering Data into Percentage Fields in Works Templates =

Article ID: 115951

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * 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 Q115951



SUMMARY
The template that uses a percentage field in Works 2.0 (AMORTIZE.WKS) and the templates that use a percentage field in Works 3.0, 4.0, 4.5, and 4.5a require the data to be entered differently.



MORE INFORMATION
In the Works 2.0 (AMORTIZE.WKS) template:

The percentage cell in this template is formatted as percentage. It requires a percentage symbol (%) after the value (for example, 10%) or the numeric value of the percentage (for example, 0.1 for 10%) to be entered. The value in the cell will then be used correctly by the formulas that reference it.

In the Works 3.0 templates and Works 4.0, 4.5, or 4.5a tasks:

These templates or tasks have percentage fields or cells that are formatted as General. They require that the value be entered as a numeric value, without the percentage symbol (%) (for example, 10 for 10%). The fields or cells that use these values include a division by 100 (/100) in their formulas to calculate the correct percentage.

Additional query words: w_works kbhowto 2.00 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a Sales Invoice Service Purchase Order Mortgage and Loan Analysis spreadsheet database Percent Divide kbimu

Keywords: kbinfo KB115951

-

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

© Microsoft Corporation. All rights reserved.