I need leading zeroes to numbers less than 5 numbers in length. HOWEVER some may have a letter at the end. SO, I am looking for a formula that will do:
1 --------->00001
12 -------->00012
123 ------->00123
1234 ----->01234
12345 ---->12345
1a -------->00001a
12b ------->00012b
123c ------>00123c
1234d ----->01234d
12345e ---->12345e
Thanks!
Bookmarks