cancel date formatting

  • Thread starter Thread starter Doug
  • Start date Start date
D

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.
 
Doug

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

Andy
 
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.
Click to expand...

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
 
Back
Top