Hello,
In the Commcare form, I have to record ID numbers of participants, and when I do export in excel, the last two or one digits changes to zero.
How to fix this?
Thank you.
Hello,
In the Commcare form, I have to record ID numbers of participants, and when I do export in excel, the last two or one digits changes to zero.
How to fix this?
Thank you.
Hi Geofrey,
Thanks for posting this. I think I can help you in this regard. As per my understanding, this issue occurs because Excel has a limitation where numbers longer than 15 digits are automatically converted into scientific notation, and the digits beyond the 15th position are replaced with zeros. Here are some resolutions to this issue:
I hope this will help you in resolving this issue. Let me know if you need further help.
Best,
Shiv
Hi Shiv,
Thank you so much. This was so helpful.