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?
|