Examples of Format Options for LS Excel / XLS Export Reporting:
mso-number-format:0 NO Decimals
mso-number-format:"0\.000" 3 Decimals
mso-number-format:"\#\,\#\#0\.000"; Comma with 3 decemial places
mso-number-format:"\#\,\#\#0"; Comma with NO decemial places
mso-number-format:"mm\/dd\/yy"; US Date
mso-number-format:"dd\/mm\/yy"; UK Date
mso-number-format:"mmmm\\ d\\\,\\ yyyy"; Date
mso-number-format:"m\/d\/yy\\ h\:mm\\ AM\/PM"; D -T AMPM
mso-number-format:"Medium Date"; 01-mar-98
mso-number-format:"d\\\.m\\\.yy\;\@"; 01.12.2005 - German Date format
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;
mso-number-format:"0\.E+00"; Fractions
mso-number-format:"\@" Text
Use within the style tags in the "head" of the XLS file being writting to disk / downloaded.
previous page
|