How can stop excel from autochanging my cut and paste data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thank you Roger Govier. I've tried that before. But it's not working. Any
other expert out there to help me up?
 
Copy the data into Notepad and save as a *.txt file.

Open that *.txt file in Excel and use the Data>Text 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
 
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.
 
I take it that you are copying it from a word type source. Pre format the
cells as text then when you go to paste them use the following process:
Edit>Paste Special> when that window opens verify that paste radio button
is toggled, highlight text, then click ok
 
I know this method. But this is not going to help me copying the color. And
the column is also another problem. This is not helping me much. Anyway,
Thanks.

Anybody can offer help?

Thank you.
 
Back
Top