Export bug:Prob using commas in text field
Hello, I have a field in my leads that I created that is of type TEXT, length 100. It holds numbers seperated by commas. For example:
100,245,123,445,988,102,809
In the CRM itself there is no problem, however when I "Export All Leads" to excel, the field will only export the first 5 numbers between commas. If the field holds the values above, it will export:
100,245,123,445,988,000,000
It truncates everything after the 5th number and replaces with zeros.
The solution is to seperate the values with a semi colon ";"
100;245;123;445;988;102;809
exports fine to Excel.