How to format a number in HTML output file with commas?
I have a straight table chart with numbers formatted as #,##0. When the chart is output to an HTML file using the ExportEx or ExportHTML statement in a macro, the amount in the cell (TD tag) is not output with the commas inserted. Is there an easy solution for this?
Just figured it out. It turns out that the Num() function doesn't respect the regional settings like the manual says it should. But wrapping the expression, e.g., Sum(Field1) in a Num() function with all parameters specified, like Num(Sum(Field1),'#,##0','.',',') works.
one not-so-good workaround is to create another similtar table with the correct format, and use it in the export macro. You can minimize it and hide it under a text box with white background... difficult to maintain though...
Just figured it out. It turns out that the Num() function doesn't respect the regional settings like the manual says it should. But wrapping the expression, e.g., Sum(Field1) in a Num() function with all parameters specified, like Num(Sum(Field1),'#,##0','.',',') works.
