Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make Excel display HTML code as text
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? |
#2
|
|||
|
|||
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 "roopytoopdongle" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
can I make pulldown text boxes in excel sheets | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
How to Make the text blink in Excel? | Excel Worksheet Functions |