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?