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