software

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

I want to paste it to MSExcel but it converts quot;17-2quot; 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: www.excelforum.com/attachment.php?postid=4341 |
-------------------------------------------------------------------

--
Roman.Plotnikov
------------------------------------------------------------------------
Roman.Plotnikov's Profile: www.excelforum.com/member.php...oamp;userid=31357
View this thread: www.excelforum.com/showthread...hreadid=510511Edit-gt;Paste Special
Select text.

or

Format the cell as text first
edit the cell (double click or hit F2) and then paste.

quot;Roman.Plotnikovquot; wrote:

gt;
gt; I have an HTML data (ex. 17-2 with quot;-2quot; in red-colored uppecase)
gt;
gt; I want to paste it to MSExcel but it converts quot;17-2quot; to calendar date
gt; (ex. 17.feb). THIS IS NOT NEEDED!
gt;
gt; I can fix the cells manually, but it takes too much time.
gt;
gt; How to fobid to excel converting (autoformatting) cell types?
gt;
gt; Thanks, Roman.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: err3.jpg |
gt; |Download: www.excelforum.com/attachment.php?postid=4341 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; Roman.Plotnikov
gt; ------------------------------------------------------------------------
gt; Roman.Plotnikov's Profile: www.excelforum.com/member.php...oamp;userid=31357
gt; View this thread: www.excelforum.com/showthread...hreadid=510511
gt;
gt;


Thank you for answer, but it doesn't help (see results in attached
pictures).

The matter that I need to paste FORMATTED text to have some handsome
result

I suppose the problem is that excel AUTOMATICALLY changes the format of
cell from text (that I have pre-formetted) to date in the very moment of
pasting. -------------------------------------------------------------------
|Filename: err5.jpg |
|Download: www.excelforum.com/attachment.php?postid=4347 |
-------------------------------------------------------------------

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