View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
berti
 
Posts: n/a
Default Pasting (replacing) problem


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