why is an apostrophe in front of text

[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

[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.

mlu wrote:
>
> 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

--

Dave Peterson

[mlu]

Thank you Dave,

It work, no more apostrophe!!!

"Dave Peterson" wrote:

> 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.
>
> mlu wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Well, no more _visible_ apostrophe <vbg>.

mlu wrote:
>
> Thank you Dave,
>
> It work, no more apostrophe!!!
>
> "Dave Peterson" wrote:
>
> > 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.
> >
> > mlu wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[Jentothephils]

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

"Dave Peterson" wrote:

> Well, no more _visible_ apostrophe <vbg>.
>
> mlu wrote:
> >
> > Thank you Dave,
> >
> > It work, no more apostrophe!!!
> >
> > "Dave Peterson" wrote:
> >
> > > 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.
> > >
> > > mlu wrote:
> > > >
> > > > 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
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

[Dave Peterson]

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

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



Jentothephils wrote:
>
> what's the deal if none of the boxes are checked (and I still have the
> apostrophe)? please advise.
>
> "Dave Peterson" wrote:
>
> > Well, no more _visible_ apostrophe <vbg>.
> >
> > mlu wrote:
> > >
> > > Thank you Dave,
> > >
> > > It work, no more apostrophe!!!
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > 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.
> > > >
> > > > mlu wrote:
> > > > >
> > > > > 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
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

[shg]

The apostrophe shouldn't affect your vlookup, assuming the apostrophes are not in front of numbers.

[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

On Thu, 6 Oct 2005 11:03:10 -0700, mlu <mlu@discussions.microsoft.com> wrote:

>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