View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Roman.Plotnikov
 
Posts: n/a
Default Problem with cell autoformat


I have an HTML data (ex. 17-2 with "-2" in red-colored uppecase)

I want to paste it to MSExcel but it converts "17-2" to calendar date
(ex. 17.feb). THIS IS NOT NEEDED!

I can fix the cells manually, but it takes too much time.

How to fobid to excel converting (autoformatting) cell types?

Thanks, Roman.


+-------------------------------------------------------------------+
|Filename: err3.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4341 |
+-------------------------------------------------------------------+

--
Roman.Plotnikov
------------------------------------------------------------------------
Roman.Plotnikov's Profile: http://www.excelforum.com/member.php...o&userid=31357
View this thread: http://www.excelforum.com/showthread...hreadid=510511