I am trying to export some data which is in numeric format with 0 as prefix to few of the values as below.
When I export this data to excel, it is changed to
How do I keep '0' in place. Currently I am prefixing this data with a quote, but I guess there should be a better solution.
For export I am creating an HTML and exporting it as xls.
Let me know if any more info is required.