Recently I need to copy and paste some data in to my excel for references.
However, whichever part I copied containing text like 1-0, 1-2 the text will
automatically change to 1/1/2000, Jan 2 etc.... Why is it so? How can I stop
that? But when I try to reformat cell to text it becomes code numbers like
36586.
Help me please. Thank you.

p/s I paste the text in HMTL form if I paste special as unicode text.