Hi all, i have a problem when exporting to CSV with a field.
this field i have is a tag number like 14-1 when exporting this and open the CSV by MS excel the field changes to Date 14-Jan automatically and even changing the format will not fix this.
is there an easy way to fix this please? i want to fix it before exporting.
Note that when you import CSV in Excel, Excel will try to determine the data type, it will think 14-1 is a date, you may test (manually edit the CSV first) if double-quoting the value (i.e. “14-1”) will make Excel think it is string. If it works, you can customize the ExportCsv class, similar to https://discourse.hkvstore.com/t/phpspreadsheet-and-titles/723/1