Extra decimal places are displayed for number fields.

 

Excel

Set the format from the cell formatting in the template file.

 

Word/PowerPoint/PDF

The values actually stored in Salesforce are output in Ver.1. Number fields can be output with the number of digits in the field definition by checking on "Adjust Format (commas/decimal places)" in the OFC_Template record.

 

Decimal point Considerations

Some standard fields, such as Opportunity Amount and Quote Amount, may have decimal points stored in Salesforce even if the decimal point is not displayed on the record screen. For example, if Opportunity Quantity contains a decimal point, Amount is stored with a decimal point even though the data type of Amount is "Currency (16, 0)". The values stored in Salesforce should be checked in the Developer Console or Dataloader.

 

*In Ver.2, decimal digits are output according to the field definition in Word, PowerPoint, and PDF. If a value exceeding the number of digits in the field definition is stored in the record value, it will be rounded to the number of digits in the field definition.

 

Instruction manual

Formatting of Currency and Number Fields (Ver.1)