I have a Vendor Number that usually is a 4 digit number, but it sometimes is 3 digit or 5 digit. I'm looking to put leading Zeroes in front of the value. That part is easy, using 00000 as the format.
The wrench to throw in here, is sometimes there is a letter character at the start. It is always at the start of the string. For example, it could be: A123 or C4321.
Is there a way to use the formatting to preserve the character, while adding the leading zeroes (if they are needed)?
Thanks