Styling Excel cells with mso-number-format

Styling Excel cells with mso-number-format

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)

2 comments:

  1. To turn off Wrap Text in the cell add the following attribute to your TD tag, style='white-space:nowrap'

    ReplyDelete
  2. Nice article. It's very helpful to me. Thank you for share with us. Can you please check my hexadecimal color codes online tool.

    ReplyDelete

Pages