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