I have a column in a file named Serial Number which is having values like -
1092534, J101KPN4, J1007PEA, 1048E75 this data is in an excel table format.
When I am copying this data to another sheet every value of this Serial Number column is written as it is but values like specific to 1048E75 are automatically converted and written in this form → 1.05E+78 but i want it in the original form only.
We would be glad if you could post the Solution method that was adopted for your query.
Posting the solution method would also help other users who come across the same issue and they would be able to solve their issues faster.