What types of special characters did you add to the AC list and which letter or
combination of letters should trigger the AC?

e.g. qwerty replace with Alt + 0186

123qwerty would give you 123º


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 14:52:00 -0700, WJason
wrote:

I'm trying to use AutoCorrect to insert special characters. (It'd be nice if
I could create shortcuts for them like I can in Word -- sigh...but even Word
inserts the character in the font in which it was created and not the font
I'm working LoL Nothing is perfect. Oops! Wrong forum.)
Anyway, I've added my AutoCorrects to the list, and I have
"Tools-Autocorrect Options...-[X] Replace text as you type" turned on. I
even have the entire worksheet formatted as text. But Excel doesn't
autocorrect anything I type. What am I doing wrong?

Jason