cancel date formatting

[Doug]

How do I cancel the feature that automatically converts
number to date. I'm using excel and want to enter the
value 1-1-0 (1 loss, 1 win, 0 tie). Excel interprets this
as 01/01/2000. when I try to format the cell to text 1-1-0
is interpreted as 36526. Please help.

 

[Andy B]

Doug

Either format the cell as text first, or enter the information with an
apostrophe before it (eg '1-1-0)

Andy

 

[Jordon]

How do I cancel the feature that automatically converts
number to date. I'm using excel and want to enter the
value 1-1-0 (1 loss, 1 win, 0 tie). Excel interprets this
as 01/01/2000. when I try to format the cell to text 1-1-0
is interpreted as 36526. Please help.

Format the cell as text before you enter it.

But think of the stats you could get if you
just entered them in separate columns.

Jordon