How can I make Excel display HTML code as text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel is winding me up.

I'm trying to past some html code into a cell and i want excel to treat it
as plain text, not display all the images and special fonts, colours etc
becaue it fouls up the rest of the sheet.

Does anyone know how I might accomplish this?
 
Hi

which version of Excel are you using - as when i copy & paste information
from the web into an excel workbook (ver 2002 or 2003) i get a smart tag
asking me if i want to keep the source formatting or match the destination
formatting - choosing "match destination formatting" gives me plain text.

Cheers
Julied
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Paste Special HTML broken in Excel/Office 2007? 1
Trying to paste in text like "01" from HTML table as text not numb 3
How do I get HTML codes in an Excel Spreadsheet to display or conv 2
HTML in cell appears as text 2
How to keep HTML in cells as code, not display??? 1
CSV->Excel Data Problem 1
Excel saved as .xls but data/text converted to html format/languag 1
How to Import Visio Text Boxes into Excel as Text 2

Back
Top