how do i get excel to stop changing my input 5-9 to 9-May????

[Guest]

i keep entering in the numbers 5-9 and i tried with spaces, 5 - 9 and yet it
still changes it as if it's a date. I turned off the auto correction control
and it still does it. Please help.

 

[Guest]

Hi, Molly;
Format> Cells> Number> Text
Then enter 5-9.
Regards,
Ian.

 

[Ragdyer]

Enter an apostrophe first,
'5-9
OR
Pre-format the cells to Text.

 

[max]

format the cell as text.