I have a column set as type TEXT. (itโs for keeping track of serial numbers). Most of our serial numbers are alphanumeric. We have a few that are numeric only. When the serial number starts with a zero but is numeric only, the app drops the zero in front. MMYY#### is the format one of our vendors use, so we have to use the same one of course. So we type in 02191234, and the app stores 2191234.
LinkedIn
Twitter
