Microsoft KB Archive/814561

= XL: When You Change the Case of Characters in a Formula, the Change Is Not Retained =

Article ID: 814561

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



SYMPTOMS
When you change the case of characters in an Excel formula, the change is not retained.

For example, if you initially type the formula =TEst in cell A1 and then press ENTER, this incorrect case formatting is retained even after you retype the formula as =TEST.



WORKAROUND
To work around this problem, close the workbook without saving it, and then reopen the workbook.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbprb KB814561

-

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

© Microsoft Corporation. All rights reserved.