Getting problem in Parse Excel Spreadsheet to CDT smart service

bhanuprakashm over 7 years ago

Hi All,
I am using "Parse Excel Spreadsheet to CDT" smart service..when i was upload the excel one of the column values contains "800001058" ,"800001058","800001058" like this.

so i am stored this values into text datatype column in cdt..but it coming like "8.000011e+08" from smart node.(before storing into db)

Can you please help me in this..

Discussion posts and replies are publicly visible

Parents

0 kondetiv over 7 years ago

can you open your excel sheet and right click on the corresponding cell and select format cells option. Now you will get one window. In that window select number tab and select category as text. Now do this for all the cells in that column. Give a try and let me know. PFA for example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kondetiv over 7 years ago

can you open your excel sheet and right click on the corresponding cell and select format cells option. Now you will get one window. In that window select number tab and select category as text. Now do this for all the cells in that column. Give a try and let me know. PFA for example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data