Phone numbers converted to scientific notation with Parse Excel Spreadsheet to CDT

#Plug-ins

Hi All,
I am using Parse Excel Spreadsheet to CDT smart service . I have a CDT that has a column 'Phn_Number' (type : string). In the excel I have a column 'Phn_Number'. In this column I am entering numbers whose length can be upto 20(say 9165432101,918012013298). While reading these values in the process model using the Parse Excel Spreadsheet to CDT smart node, the numbers are getting converted to exponential values (9.165432e+09, 9.18012e+11) . I am formatting the cells in the excel to Number(with Decimal places 0). How do I overcome this ? I need to retain the same values that are being uploaded in the excel sheet.
Thanks..

OriginalPostID-178323

OriginalPostID-178323

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data