I have a list of numbers that have 3 digits after the dash (FL-100), but in the list are numbers that are formatted with only 2 digits after the dash (AR-12). They all need leading zeroes in order to have 3 digits after the dash. I have tried the TEXT function with no luck because Excel isn't recognizing these as text for some reason. Does anyone have any suggestions to add a leading zero ONLY to the figures with 2 digits after the dash, in a list including figures that are already formatted properly with 3 digits? A sample of the list is attached.
FL-05
FL-08
FL-100
FL-101
FL-102
FL-103
FL-104
Thanks in advance, folks!