Stop autocomplete

[bigal40]

Anyone know who to stop Excel from changing 10/10 or 10-10 into 10-Oct? It is really annoying and I can;t figure out how to make it stop.

 

[minendo]

Input it as comments by typing '10/10.

 

[bigal40]

thanks

 

[TheoPetro]

cnat you right click on the cell, select format, and change the cell type to a different format?