Hi there,
When I export the Contacts list from Sugar to Excel, the phone numbers in some cases get 'corrupted', since Excel (I assume) tries to interprete them as formulas in about 10% of the cases.
An example
Sugar : +49 4131/77- 2536
Excel interpretes as ; =102,649350649351- 2536
Excel displays the result : -2433,350649
Reason is , that the Phone info is exported into a 'General' formatted cell of Excel.
If I could switch those phone info cells to Text formatting , all would be fine.
Does anybody has a trick how I can fix this in the Export of Sugar ?
Thanks !
Hugo
Hi Hugo,
Out of the box, Sugar exports the records in a CSV file and not an excel file. By Excel File I am assuming .xlsx or .xls file. Are you using a plugin to export the records? Because if so, it could be a plugin specific issue.
Try exporting the records as a csv file and you should be good to go.
Let me know if this solves your problem.