Leading zero getting truncated in .CSV format GUI_DOWNLOAD

Hello experts,

I am trying to download the data using GUI_DOWNLOAD in .CSV format but the leading zeros are getting truncated. For instance Company code 0001 is displayed as 1 in the CSV File. But when I open the same file in notepad I am seeing 0001. Is this a known issue or this is how .CSV format should be?

I have gone through some threads in SDN but they are not helpful.

Your expert advise is much appreaciated.

Thanks

Abdul Hakim