How to keep leading zero in CSV file when exporting a report

[PatriciaA987250]

Hi,

I'm creating a report using database view and the report will be exported to a csv file format. The report generation and distribution will be automated. The issue here, when the report exported to csv file format, some data are not displaying as expected e.g. those values with leading zero (00012345 only display as 12345). How can i address this issue? kindly advise.

 

[maheshkn]

Hello,

Change the field type to string. It will retain the Zero's