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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excel doubter - 02 Oct 2006 15:25 GMT

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.

Reply to this Message

Roger Govier - 02 Oct 2006 17:19 GMT

Hi

Try pre-formatting the column as Text. Format>Cells>Text

Signature

Regards

Roger Govier

> Recently I need to copy and paste some data in to my excel for
> references.
[quoted text clipped - 8 lines]
>
> p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message

Excel doubter - 03 Oct 2006 17:03 GMT

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

> Hi
>
[quoted text clipped - 12 lines]
> >
> > p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message

Gord Dibben - 03 Oct 2006 17:41 GMT

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 Roger Govier. I've tried that before. But it's not working. Any
>other expert out there to help me up?
[quoted text clipped - 15 lines]
>> >
>> > p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message

Excel doubter - 04 Oct 2006 17:55 GMT

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.

> Copy the data into Notepad and save as a *.txt file.
>
[quoted text clipped - 23 lines]
> >> >
> >> > p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message

SSG QuarterMaster - 05 Oct 2006 04:12 GMT

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

> 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.
[quoted text clipped - 33 lines]
> > >> >
> > >> > p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message

Excel doubter - 05 Oct 2006 14:21 GMT

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.

> 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:
[quoted text clipped - 38 lines]
> > > >> >
> > > >> > p/s I paste the text in HMTL form if I paste special as unicode text.

Reply to this Message