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