Microsoft KB Archive/138077

= OFF95: AutoCorrect Change to Period Affects Numbers in MS Excel =

Article ID: 138077

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Office 95 Standard Edition
 * Microsoft Word 95 Standard Edition

-



This article was previously published under Q138077



SYMPTOMS
When you use Microsoft Word version 7.0, you can click AutoCorrect on the Tools menu and choose to replace the period with a period followed by a space. Making this change to AutoCorrect means that you do not need to press the SPACEBAR after you type a period at the end of a sentence.

If you make this change you may receive unexpected results in Microsoft Excel version 7.0. Specifically, when you enter numbers that contain decimal points in Microsoft Excel, the numbers have a space after the decimal point and are formatted as text.



CAUSE
AutoCorrect is a shared feature in Microsoft Office for Windows 95 programs. Any change you make to AutoCorrect is reflected in all Microsoft Office programs that use AutoCorrect.



RESOLUTION
If an undesirable side-effect occurs in a program due to AutoCorrect, undo the change or disable AutoCorrect in the affected program. To disable the feature, click AutoCorrect on the Tools menu, clear the Replace Text As You Type check box, and click OK.



STATUS
This behavior is by design of the AutoCorrect feature.

Additional query words: 95

Keywords: KB138077

-

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

© Microsoft Corporation. All rights reserved.