AutoCorrect Uses Smart Apostrophes, Not Standard Apostrophes (178423)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q178423 SYMPTOMS
In the versions of Microsoft Excel listed above, the AutoCorrect feature
uses "smart" apostrophes when it corrects text. This may cause a problem
if you expect the corrected text to contain standard apostrophes.
CAUSE
This problem occurs because the entries in the AutoCorrect list contain
"smart" apostrophes, not standard apostrophes. The following entries are
affected:
aren't it'll what's
can't it's where's
can't have been it's a who's
company's it's not who've
couldn't it's the won't
didn't let's wouldn't
doesn't she'll you'd
don't shouldn't you're
don't know that's you're a
hadn't they'll you're an
hasn't they're you're her
haven't they've you're here
he'll wasn't you're his
here's we'd you're my
I'm we'll you're the
I'd we're you're their
I'll we've you're your
isn't weren't you've
This behavior is by design of Microsoft Excel.
WORKAROUND
If, as a result of using the AutoCorrect feature, your worksheet contains
a number of "smart" apostrophes, you can replace the "smart" apostrophes
with standard apostrophes. To do this, use the appropriate method for your
version of Excel.
Excel 97 for Windows- On the Edit menu, click Replace.
- Place the insertion point in the Find What box. Hold down the ALT
key while you type 0146, using the
number keys on the numeric keypad. Release the ALT key. This enters a
"smart" apostrophe in the edit box.
- In the Replace With box, type an apostrophe (').
- Click Replace All.
All of the "smart" apostrophes in the worksheet are replaced by
standard apostrophes.
Microsoft Excel 98 Macintosh Edition- On the Edit menu, click Replace.
- Place the insertion point in the Find What box. Press OPTION+SHIFT+]
(right square bracket). This enters a "smart" apostrophe in the edit
box.
- In the Replace With box, type an apostrophe (').
- Click Replace All.
All of the "smart" apostrophes in the worksheet are replaced by
standard apostrophes.
Modification Type: | Minor | Last Reviewed: | 8/19/2003 |
---|
Keywords: | kbprb KB178423 |
---|
|