Export registration list formatting issue

Hi, tuan.

i noticed that when exporting registrant data that contain 00 at the beginning, the 0 that start at the beginning will disappear.
example:-

IC no:
0012345678
after export it will became
12345678

In malaysia, people that born after year 2000 the ic no will be start with 00,
we need to know is there any solutions to solve this?

This is more with how you bring the exported file into your spreadsheet rather than the export, I believe.

Do you export as csv or xlsx?

Yes. I believe so. It is not a problem with the export itself but it is a problem with Excel program trying to format the text as number

Try to check format of the row , change it to Text.... would solve the issue

Tuan