Hi

Try pre-formatting the column as Text. FormatCellsText

--
Regards

Roger Govier


"Excel doubter" <Excel wrote in
message ...
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.