Hello Sheet Experts,
I am trying to create a Glide searchable field for UPC code in Sheets. When I use the number or text format, Google removes any preceding zeros ( example: 025293600713 becomes 25293600713) . Can anyone suggest how can I format the cell to avoid this and still remain searchable in Glide.
your help is appreciated