Need to remove leading zeros
I have a column that represents 'Store #'. Store #'s are 4 digits, i.e., 0001 or 0010 or 0100 or 1000
This becomes a bit of an issue when sorting the column.
I am creating a helper row for purposes of sorting and want to remove the LEADING zeros, however, am having trouble figuring out how to accomplish this.
Help Article Resources
Check out the Formula Handbook template!