why is an apostrophe in front of text

M

mlu

After entering a text in a cell or in the function field, when i go back in
the cell an apostrophe apear in front of the text.

How can i correct this?

Thank you
 
D

Dave Peterson

Try:
Tools|Options|transition tab
Uncheck "transition navigation keys"

I've unchecked all those Lotus 123 transition settings. If you need them, don't
do it. But if you're like most excel users, I'd uncheck them.
 
M

mlu

Thank you Dave,

It work, no more apostrophe!!!

Dave Peterson said:
Try:
Tools|Options|transition tab
Uncheck "transition navigation keys"

I've unchecked all those Lotus 123 transition settings. If you need them, don't
do it. But if you're like most excel users, I'd uncheck them.
Click to expand...
 
G

Gord Dibben

Go to Tools>Options>Transition tab and uncheck any Lotus checkboxes.

Specifically "transition navigation keys".

I bet you are getting other strange things happening also.

Like hit Tab key and the whole sheet moves.


Gord Dibben Excel MVP
 
J

Jentothephils

what's the deal if none of the boxes are checked (and I still have the
apostrophe)? please advise.
 
D

Dave Peterson

Checking the "transition navigation keys" only allows you to see that
apostrophe.

It doesn't clean any visible (or invisible) apostrophe.


what's the deal if none of the boxes are checked (and I still have the
apostrophe)? please advise.
Click to expand...
 
Top