7 Replies Latest reply: Dec 8, 2016 4:46 PM by Bharat Ahuja RSS

    Formatting numbers

      Can someone please tell me what I need to add to the script to make sure I'm showing no decimal points in my calculations?

       

      LOAD [Opportunity Name: Opportunity Name],

           Vendor,

           [Country Name],

           [LOG Description],

           [PO Number],

           Status,

           [LOG Received],

           [Invoice Received],

           [Bill Date],

           [Total Request Amount],

           [Reimbursement Amount]

      FROM

      [C:\Users\murphyc2\Desktop\Vendor Status Report_010512.xlsx]

      (ooxml, embedded labels, table is report1357406142116);

       

      Total Request Amt and Reimbursement Amt both have two decimal points which I'd like to not show if possible. Thanks.