HTML Table Cell Styling for Excel by using “mso-number-format”

HTML CSS table cell styling for manipulating the data format in Excel. Very useful for publishing an Excel document for download.

Attribute	Description
mso-number-format:”0″	NO Decimals
mso-number-format:”0.000″	3 Decimals
mso-number-format:”#,##0.000″	Comma with 3 dec
mso-number-format:”mm/dd/yy”	Date7
mso-number-format:”mmmm\ d,\ yyyy”	Date9
mso-number-format:”m/d/yy\ h:mm\ AM/PM”	D -T AMPM
mso-number-format:”Short Date”	01/03/1998
mso-number-format:”Medium Date”	01-mar-98
mso-number-format:”d-mmm-yyyy”	01-mar-1998
mso-number-format:”Short Time”	5:16
mso-number-format:”Medium Time”	5:16 am
mso-number-format:”Long Time”	5:16:21:00
mso-number-format:”Percent”	Percent – two decimals
mso-number-format:”0%”	Percent – no decimals
mso-number-format:”0.E+00″	Scientific Notation
mso-number-format:”@”	Text
mso-number-format:”#\ ???/???”	Fractions – up to 3 digits (312/943)
mso-number-format:”\0022£\0022#,##0.00″	£12.76
mso-number-format:”#,##0.00_ ;[Red]-#,##0.00\ “	2 decimals, negative numbers in red and signed (1.56 -1.56)

The origin of the info is obtained from an article written by Mich Rodz, published at Medium.com.