Merge Field How do I display negative numbers with parentheses? e.g. (1,000)
The data type is Currency or Date/Time can be set the formatting. Available in Ver.2.0 or later.Word/PowerPoint/PDFMerge...
Merge Field Merge Field How do I output the currency symbol?
The data type is Currency or Date/Time can be set the formatting. Available in Ver.2.0 or later.Word/PowerPoint/PDFe.g. ...
Merge Field How do I round a number to a specified number of decimal places?
The data type is Currency or Date/Time can be set the formatting. Available in Ver.2.0 or later.Word/PowerPoint/PDFe.g. ...
Template Common Extra decimal places are displayed for number fields.
ExcelSet the format from the cell formatting in the template file.Word/PowerPoint/PDFThe values actually stored in Sales...
Excel Decimal points are truncated.
Set the format from "Format Cells" in Excel.Instruction manualExcel
Template Common Number fields are not output with 3-digit comma delimiters.
ExcelSet the format from the cell formatting in the template file.Word/PowerPoint/PDFCheck on "Adjust Format (commas/dec...
Template Common The currency symbol for the currency field is not output.
The currency symbol is not output.ExcelSet the format from the cell formatting in the template file.Word/PowerPoint/PDFF...