Ahhaa

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Does the single quote change to double quote if you right-align or change to an
caret (^) if you center-align?

My guess is you have Transition Navigation Keys enable under
ToolsOptionsTransition.

Uncheck that option and the two below it.


Gord Dibben MS Excel MVP

On Sun, 25 Feb 2007 04:43:13 -0800, oldtimer
wrote:

Whenever I start a new workbook, if I enter text into a cell and press enter,
in the formula bar the text is preceded with a single quote. I have obviously
switched something on somewhere for this to happen. I know I can do a
Find/Replace, but I don't want to do this for every workbook I produce. Does
anybody know how to switch it off?