Avoid automatic deletion of number in excel sheet after exporting the data
Avoid automatic deletion of number in excel sheet after exporting the data
Ponmurugan
Posts: 4Questions: 1Answers: 0
I have exported some data to excel from jquery datatable.. I have a column like ticket No that contains numeric and characters like ticket numbers are( GHL5YW0, 0100000000) etc.. After exporting the data to excel if click this value (0100000000) of this cell, then going to next cell by pressing tab key the zero is deleted automatically (0100000000 => Converted to 100000000). I tried to convert the column datatype to text but it is not working well.. Please give me the Proper Solution for us
Replies
Try this trick from this thread. Could you look at that, please, and see if it helps. If it's still not working for you, please can you update my example, or link to your page, so that we can see the problem.
Cheers,
Colin