View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Duardo Duardo is offline
external usenet poster
 
Posts: 3
Default 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?