Thank you for your Idea God Dibben. But I want to retain the colourful table
as it is on the web, so that I don't have to do colour coding by myself.

So, any other guys with better idea?

It's driving me mad. Everything is perferct except the part with the hypen
like 2-0, 1-0,1-2 etc....

Somebody please help me. Thank You.


"Gord Dibben" wrote:

Copy the data into Notepad and save as a *.txt file.

Open that *.txt file in Excel and use the DataText to Columns wizard to parse
your data and on page three of T to C you can designate "Column Data Format" as
Text.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:03:01 -0700, Excel doubter
wrote:

Thank you Roger Govier. I've tried that before. But it's not working. Any
other expert out there to help me up?

"Roger Govier" wrote:

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.