OFF95: AutoCorrect Change to Period Affects Numbers in MS Excel (138077)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Office for Windows 95
- Microsoft Word for Windows 95
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.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | KB138077 |
|---|
|