Sharepoint - how to show HTML code in column?

By far the easiest method to do this is to simply set the "data type returned from this formula" setting on your column to be "Number".

Against all logic, this interprets your formula as HTML. I'm not sure if this works in 2007, but it certainly works in 2010 and 2013. Since there are 10,000 views on this topic and very few up votes, I'm guessing this is a much better answer for the wider community than any of the answers given.


Have a look at the solution described in this post: Using calculated columns to write HTML


original post (links are broken)

elcapitano, my tutorial should work:

http://blog.pathtosharepoint.com/2008/09/01/using-calculated-columns-to-write-html/

A couple notes:

  • in the above post, you'll find a link to a troubleshooting page
  • there are several versions of the Text to HTML script, I recommend that you pick the latest one (v 2.1.1) here: http://sp2010.pathtosharepoint.com/SharePoint-User-Toolkit/Downloads/

If it doesn't work, feel free to share your HTML string (calculated column output) and I'll take a look.


We've recently released a free HTML Calculated Column; it acts just like a calculated column, but won't escape HTML:

Pentalogic's SharePoint HTML Calculated Column

Disclaimer: I work for Pentalogic; on this project actually. Oh, and I'm afraid you have to sign up for our newsletter, but that isn't a bad trade (in my unbiased opinion). :)

Tags: