Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HTML tags in excel

Status
Not open for further replies.

Giddygoat

Programmer
May 16, 2001
36
GB
Hello

I generating an excel worksheet from via a web application. Some data is "rich text" and stored with html tags. When I open the spreadsheet the tags are shoen in plain text i.e. <b>Look at this</b> instead of Look at this

Is there a setting in excel that can cause the html tags to be rendered?

Thanks

John
 
Hi John,

Have you tried to change the format of the cells by going to "Cells", "format cells", "custom" and typing HTML in the "type"?

It might just work...

Livia

 
Save the html-tagged text as an HTML file and then open it in excel.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top