Answered
When I export submissions that contain a scanned barcode with a leading "0" to a .CSV, the file drops the leading "0," which obviously changes the value. Is there a setting to correct this?
0
Comments
Please sign in to leave a comment.
Hi Toby,
When you export submission and open it in excel by default excel would remove leading '0' from the barcode number. This is due to Excel formatting the cell resulting in removal of leading '0'.
To resolve the issue here is a Microsoft support article (Section: Convert numbers to text when you import text data) on how to stop excel formatting the cell within excel: https://support.office.com/en-us/article/keeping-leading-zeros-and-large-numbers-1bf7b935-36e1-4985-842f-5dfa51f85fe7