Microsoft KB Archive/206123

= WD2001: Formula Calculation Using the 0.00% Format Produces Incorrect Results =

Article ID: 206123

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Word 2001 for Mac

-



This article was previously published under Q206123



SYMPTOMS
When you enter a calculation using the 0.00% format, you may receive incorrect results. For example, the formula {=4/2 \# "0.00%"} gives a result of 2.00% rather than the expected 200%.



WORKAROUND
To work around this issue, avoid using percent (%) formats in your formula. Instead, use the basic number (0) format combined with a simple calculation to determine percentages, and then add the percent symbol after your formula.

For example, to enter a formula to produce the percent difference between x and y, use the calculation (x/y)*100 in your formula.

To do this, follow these steps:
 * 1) Start Microsoft Word 2001.
 * 2) On the Table menu, click Formula.
 * 3) In the Formula box, type =(4/2)*100.
 * 4) In the Number Format list, click 0, and then click OK.
 * 5) Press the percent (%) key.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Word 2001 Macintosh Edition.



MORE INFORMATION
Press OPTION+F9 to toggle (show or hide) the field codes.

Press COMMAND+F9 to add an empty field.

Additional query words: OFF98 mac macword WD2001KB

Keywords: kbbug kbpending KB206123

-

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

© Microsoft Corporation. All rights reserved.