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

--
Kind regards,

Niek Otten

"berti" wrote in
message ...

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?


--
berti
------------------------------------------------------------------------
berti's Profile:
http://www.excelforum.com/member.php...o&userid=29597
View this thread: http://www.excelforum.com/showthread...hreadid=492987