Making text appear in cell as written

S

SnoLepard

I try to write a sports team's record in a cell, for example 5-3, but as soon
as I enter the text it will be converted to May 3 or to 5/3/2006. I cannot
imagine why this program assumes I am enetering a date. I am not.

I have tried to format the cell to 'general' so that the text appears as
written but this function does not prevent the transformation to a date.
 
D

Domenic

Either format the cell as 'Text' or precede your text entry with a
single quote...

'5-3

Hope this helps!
 
Top