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

[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

[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
"astrange" <[email protected]> wrote in
message news:[email protected]...
|
| 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...o&userid=32275
| View this thread: http://www.excelforum.com/showthread...hreadid=530877
|

[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
"astrange" <[email protected]> wrote in
message news:[email protected]...
|
| 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...o&userid=32275
| View this thread: http://www.excelforum.com/showthread...hreadid=530877
|