write a function to pad the number. Send it the number and an integer value representing the length it should be in characters.
VB Code:
Public Function LPAD (sNumber as String, Length as Integer) as String LPAD = String$(Length - Len(sNumber) , "0") & sNumber End Function




Reply With Quote