When exporting numeric fields which have a meaningful leading zero, such as a bank account number or sort code, it would be useful if these could be exported as strings, i.e. by enclosing the field in the csv row within quotation marks.This would overcome the problem where if the csv file is opened directly in Excel the bank account field is treated as numeric and Excel removes the leading zero and thus makes the value of the bank account number field incorrect. We realise that it is possible to use Excel's import function to do a more controlled transformation of the data and ensure that the field is treated as string, but users tend to open the csv file directly into Excel which causes leading zeroes to be removed.
Hi Hayley. Thanks for the suggestion. It sounds like we should perhaps give any user the option to choose whether to export using quotation marks - that way those that want to can etc. I'll raise this up for review.
Cheers
Dylan