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.
Source: https://medium.com/@mrodz/styling-excel-cells-with-mso-number-format-css-attribute-71d9da54edae