Apostrophe In Every Cell

[astrange]

When I enter text in any cell in any workbook or worksheet and then exit
that cell, an apostrophe is automatically placed at the beginning of
that cell.

1. Enter a cell, there is nothing in that cell or in the edit bar at
the top
2. Type abc and then tab out of the cell
3. Arrow back to that cell
4. The cell displays abc but the edit bar up top displays 'abc

This does not appear to cause any kind of a problem but it is annoying
to not know why it happens. I figure it is some kind of setting but I
have been unable to determine which one it is.

I would appreciate any thoughts.

Thanks,
Jason

 

[Jim Rech]

The apostrophe appears because you have selected "Transition navigation
keys" under Tools, Options, Transition.

This makes Excel behave in some ways like 1-2-3, which always has text
entries start with a "label align character".

--
Jim
message |
| When I enter text in any cell in any workbook or worksheet and then exit
| that cell, an apostrophe is automatically placed at the beginning of
| that cell.
|
| 1. Enter a cell, there is nothing in that cell or in the edit bar at
| the top
| 2. Type abc and then tab out of the cell
| 3. Arrow back to that cell
| 4. The cell displays abc but the edit bar up top displays 'abc
|
| This does not appear to cause any kind of a problem but it is annoying
| to not know why it happens. I figure it is some kind of setting but I
| have been unable to determine which one it is.
|
| I would appreciate any thoughts.
|
| Thanks,
| Jason
|
|
| --
| astrange
| ------------------------------------------------------------------------
| astrange's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=32275
| View this thread: http://www.excelforum.com/showthread.php?threadid=530877
|

 

[Ron Coderre]

You have Excel set to behave like Lotus 1-2-3.

Try this:

<Tools><Options><Transition>
Uncheck: Transition navigation keys

Does that help?

Regards,
Ron

 

[astrange]

Thanks guys,

That solved the problem. In fact, that is the second time that I have
had something weird happen due to Transition Navigation Keys being
turned on. I am certain that I never go into Options to turn that
option on.

Is there some combination of keys that I press or anything else that I
might unwittingly be doing that turns this option on?

Thanks again for the help. This forum is great.

Jason

 

[Jim Rech]

Is there some combination of keys that I press

I don't think so. A workbook that started out as a Lotus 1-2-3 file (*.WK?)
will open like this until you change it though (and save it in Excel
format).

--
Jim
message |
| Thanks guys,
|
| That solved the problem. In fact, that is the second time that I have
| had something weird happen due to Transition Navigation Keys being
| turned on. I am certain that I never go into Options to turn that
| option on.
|
| Is there some combination of keys that I press or anything else that I
| might unwittingly be doing that turns this option on?
|
| Thanks again for the help. This forum is great.
|
| Jason
|
|
| --
| astrange
| ------------------------------------------------------------------------
| astrange's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=32275
| View this thread: http://www.excelforum.com/showthread.php?threadid=530877
|