Is there a way to format one of the columns on a CSV export so that it is treated as quoted text?
I have a column that contains tracking numbers and if there are any leading zeros, the data is being truncated when the file is opened in Excel.
These two examples show how to modify the exported data:
I think you will find that wrapping quotes around cell data when exported as a CSV will be seen if opened in Excel. If you want to format the data for Excel you should use the Excel export option. There are lots of threads discussing how to convert strings to text for Excel, like this one:
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.