How to remove the ' ^ etc. in Excel 2007?
 

Hi,

How do I remove the ' ^ etc. from showing in Excel 2007? It tends to
make the online search useless because it affixes those symbols (symbols for
bold, center, etc.)

Here's a sample screenshot -
http://farm1.static.flickr.com/154/4...281a695b_m.jpg

In the screenshot, there is ' If I remove it, the text/cell formatting
is deleted as well. If I say, bold it again or otherwise, it will come back.
I tried turning off everything in Excel 2007 settings, but for some reason
it still stays, so I'm really at a lost as to what setup it really is or
where can I find that setup.

Thank you very much!!

How to remove the ' ^ etc. in Excel 2007?
 

I don't have 2007 but in earlier versions those were left, center and
right-aligned marks caused by having Transition Navigation Keys enabled in
ToolsOptionsTransition.

Maybe 2007 still retains this Lotus feature?


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 09:55:00 -0700, Laibeus Lord <Laibeus
wrote:

Hi,

How do I remove the ' ^ etc. from showing in Excel 2007? It tends to
make the online search useless because it affixes those symbols (symbols for
bold, center, etc.)

Here's a sample screenshot -
http://farm1.static.flickr.com/154/4...281a695b_m.jpg

In the screenshot, there is ' If I remove it, the text/cell formatting
is deleted as well. If I say, bold it again or otherwise, it will come back.
I tried turning off everything in Excel 2007 settings, but for some reason
it still stays, so I'm really at a lost as to what setup it really is or
where can I find that setup.

Thank you very much!!