Pasting HTML formatted text as plain text in Excel

I often use excel to do bulk translations of HTML formatted data into other formats.

However, now with Excel 2007, when I paste a block of HTML code from notepad or any plain text editor into excel, excel will actually parse the HTML and display the data as HTML including pictures and fonts. All the source HTML is apparently gone, and all I can see is the output.

Paste special only gives the option of unicode text or plain text and both yield the same results.

This is obviously useless as I can no longer edit the souce text.

I have looked through the MS help files and knowledge base and I have searched these forums, but I still can't find any way to change MS options or preferences to not actually interpret the HTML.

Any thoughts would be greatly appreciated.