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?
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
Please sign in to leave a comment.
Comments
1 comment