Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
In my colleagues Excel (2000), when you enter text or numbers in a Cell, an
apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
Sounds like the cell is formatted for Text. Format it as General, then
re-enter your data. Does that solve the problem? Regards, Fred. "Duardo" wrote in message ... In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
Hi Fred,
I know about this. Format is general. Change does not help. It is default for all cells. "Fred Smith" wrote: Sounds like the cell is formatted for Text. Format it as General, then re-enter your data. Does that solve the problem? Regards, Fred. "Duardo" wrote in message ... In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
If you're sure the apostrophe isn't there on purpose to protect leading zeros
or numbers (like long part numbers) that would change to scientific notation, just insert a new sheet, copy all the cells at once, and then PASTE SPECIAL - VALUES only into the new sheet and the ' should be gone. "Duardo" wrote: Hi Fred, I know about this. Format is general. Change does not help. It is default for all cells. "Fred Smith" wrote: Sounds like the cell is formatted for Text. Format it as General, then re-enter your data. Does that solve the problem? Regards, Fred. "Duardo" wrote in message ... In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
ToolsOptionsTransition.
Clear out the Transition Options. See if that helps. Although you should still be able to enter numbers with those options enabled so not sure what's going on. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 07:47:01 -0800, Duardo wrote: Hi Fred, I know about this. Format is general. Change does not help. It is default for all cells. "Fred Smith" wrote: Sounds like the cell is formatted for Text. Format it as General, then re-enter your data. Does that solve the problem? Regards, Fred. "Duardo" wrote in message ... In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
Are you sure that the cells are not formatted as text? It sure sounds like they
are. There's a setting in excel that allows you to see this apostrophe prefixcharacter: Tools|Options|Transition Tab|Uncheck "Transition Navigation keys" to turn it off. But this won't affect numbers or dates. But cells formatted as Text will have this problem with numbers/dates. Duardo wrote: In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
Thanks for this.
I had checked this tab already, and nothing is set here, same a my Excel (without this problem). Nothing is formatted, this is default as you start up (his) Excel. Cell format is General. All cells have the apostrofe. Dates are effected, not recognised as dates, but text. Could this be the result of a macro (used in other files) There are no macro's in his file. "Dave Peterson" wrote: Are you sure that the cells are not formatted as text? It sure sounds like they are. There's a setting in excel that allows you to see this apostrophe prefixcharacter: Tools|Options|Transition Tab|Uncheck "Transition Navigation keys" to turn it off. But this won't affect numbers or dates. But cells formatted as Text will have this problem with numbers/dates. Duardo wrote: In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrofe in cell by default
I still don't have a guess, but you can check to see if it's a macro by starting
excel in safe mode and then test it out. Close Excel Windows start button|Run type: excel /safe and hit enter Then try it out. Starting in safe mode will prohibit macros from even starting (along with some other stuff). Duardo wrote: Thanks for this. I had checked this tab already, and nothing is set here, same a my Excel (without this problem). Nothing is formatted, this is default as you start up (his) Excel. Cell format is General. All cells have the apostrofe. Dates are effected, not recognised as dates, but text. Could this be the result of a macro (used in other files) There are no macro's in his file. "Dave Peterson" wrote: Are you sure that the cells are not formatted as text? It sure sounds like they are. There's a setting in excel that allows you to see this apostrophe prefixcharacter: Tools|Options|Transition Tab|Uncheck "Transition Navigation keys" to turn it off. But this won't affect numbers or dates. But cells formatted as Text will have this problem with numbers/dates. Duardo wrote: In my colleagues Excel (2000), when you enter text or numbers in a Cell, an apostrofe appears in front of the data in the cell by default. Restarting Excel does not help. As Excel considers this to be text, we run into problems with dates etc. Any idea what causes this? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Cell Style | Excel Discussion (Misc queries) | |||
default name and value in input cell | Excel Worksheet Functions | |||
Default cell name and value | Excel Worksheet Functions | |||
set a default value for a cell ? | New Users to Excel | |||
Default cell alignment | Excel Discussion (Misc queries) |