AnsweredAssumed Answered

Controling the cell format of Excel for Sugar exports

Question asked by Hugo Geyskens on Dec 6, 2018

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