Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Every Cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Every Cell
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 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Every Cell
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 -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=530877 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Every Cell
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Every Cell
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" wrote in 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...o&userid=32275 | View this thread: http://www.excelforum.com/showthread...hreadid=530877 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) |