Pasting (replacing) problem

[berti]

Hi!
How can I prevent changing all my "01/1" to "1.jan" (or to "38353")
when copying tables from Word to Excel or when running Find/Replace
tool.

The only way I can get those "01/1" is to select text format of a cell
and type it manually.

But I have thousands of "01/1" (01/2, 01/3 ... 02/1, 02/2 ...)
cells.

Any idea?

 

[Niek Otten]

Format the receiving cells as text before you paste. Use Paste special,
click Text

 

[berti]

Ok, that aswers my question, but ..
what if I would like to keep the same format as it was in Word?
I mean, with this solution I get unformatted text in one column and
then have to use Text import wizard to get columns
with a tab delimiter (and again forse the columns with 01/1 to text
format)
and then put borders around them.

Thanks,
Berti

 

[Niek Otten]

Paste special as Microsoft Office Word document object

 

[berti]

Yes, that is true, but it doean't help me, cause then I don't
have cells, just one object!

My problem is that a have lots of tables made in Word
but now i would like to do sth. with their data in Excel.

It seems that a best solution would be to replace / with e.g. \.
In my case 01/1 means round/location so changing it to \ won't
damage anything.

I have the same problem with ":".
2:0 should represent a result (score) in my table, but gets converte
to 2:00, time!

Maybe I can disable this automatic formatting somwhere?

Regards,
Berti