1- Change date format to dd-mmm-yy hh:mm:ss or mmm-dd-yy hh:mm:ss. Eliminating the commas used in the date means excel will not split the date into multiple columns
2- Amount & Balance values double quoted or formatted to exclude commas. Again this will ensure that amount or balance will not be split into multiple columns by Excel when opening the CSV
3- Delimiter changed to comma from the current semi-colon. Alternatively an option to select comma, tab or semicolon as Delimiter
Please sign in to leave a comment.