genuineblonde
Technical User
I am trying to concantenate two Integer values. I need the second to display leading zeros. How do I format?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Leading Zeros
- Thread starter genuineblonde
- Start date
- Status
JohnYingling
Programmer
I assume as a string.
Code:
Function LeadingZ(strInt as string,intDigits as integer) as string
LeadingZ = Right(String(intDigits,"0") & Ltrim(strInt),intDigits)
End Function- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question