Format$ Examples

Mindwatering Incorporated

Author: Tripp W Black

Created: 11/26/2007 at 01:06 PM

 

Category:
Notes Developer Tips
LotusScript

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