Breaking News: Grepper is joining You.com. Read the official announcement!

vba Leading Zeros

László Vas answered on August 18, 2020 Popularity 4/10 Helpfulness 3/10

answer vba Leading Zeros

related vba leading zeros in string

vba Leading Zeros

Comment

Function AddLeadingZeroes(ref As Range, Length As Integer)
Dim i As Integer
Dim Result As String
Dim StrLen As Integer
StrLen = Len(ref)
For i = 1 To Length
 If i <= StrLen Then
 Result = Result & Mid(ref, i, 1)
 Else
 Result = "0" & Result
 End If
Next i
AddLeadingZeroes = Result
End Function

Popularity 4/10 Helpfulness 3/10 Language vb

Source: exceltrick.com

Tags: vba

Link to this answer
Share Copy Link

Contributed on Nov 03 2022

László Vas

0 Answers Avg Quality 2/10

Closely Related Answers

vba leading zeros in string

Comment

MsgBox format(12,"0000")	' OUTPUT:  0012

Popularity 7/10 Helpfulness 7/10 Language vb

Source: stackoverflow.com

Tags: vba string

Link to this answer
Share Copy Link

Contributed on Aug 18 2020

Thoughtless Tapir

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

vba Leading Zeros

Contents

More Related Answers

vba Leading Zeros

Closely Related Answers

vba leading zeros in string

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.