Payment file format - when the amount is an integer, eg 500.00, when exporting to CSV, Excel formats this to 500. This is an issue because all amounts need to have a decimal point. How to resolve?

AI generated answer (using internal Slack threads):

The issue you're experiencing is related to how Excel automatically formats numbers when opening a CSV file. Excel will remove trailing zeros after the decimal point for numbers, which is why you're seeing 500 instead of 500.00. To resolve this, you can change the formatting settings in Excel. Here's how you can do it: 1. Open Excel and go to the 'File' menu. 2. Click on 'Options'. 3. In the Excel Options dialog box, click on 'Advanced'. 4. Scroll down to the section 'When calculating this workbook'. 5. Check the option 'Set precision as displayed'. 6. Click 'OK' to close the dialog box. This will ensure that Excel maintains the decimal precision as it is displayed in the cells. Alternatively, you can also format the cells in Excel to always display two decimal places. Here's how: 1. Select the cells that you want to format. 2. Right-click on the selected cells and click on 'Format Cells'. 3. In the Format Cells dialog box, click on 'Number'. 4. Set the decimal places to 2. 5. Click 'OK' to close the dialog box. This will ensure that the selected cells always display two decimal places, even if the number is a whole number. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******