Leading Zeros Dropped in Cell

By default, Google will remove any leading zeros in data. This can cause problems with data points such as bar codes.

Example of a barcode with leading zeros

Example output in Google Sheets


Simply add a leading apostrophe ' in the cell in Instasheets. Now Google will no longer drop the leading zero when the data is sent to the Sheet.