AnsweredAssumed Answered

Controling the cell format of Excel for Sugar exports

Question asked by Hugo Geyskens on Dec 6, 2018
Latest reply on Jan 23, 2019 by Rolustech Support

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

Outcomes