Pad single-digit numbers with a zero Pad single-digit numbers with a zero vba vba

Pad single-digit numbers with a zero


vba excel for-loop

VBA has a Format() function that you can use to pad numbers.

animal = "sinani-" & Format$(i, "00")

This will pad single-digit numbers with a 0. Your two- and three-digit numbers will continue to work as expected.

vba excel for-loop

In the fifth line use the Format function like this:

animal = "sinani-" & Format(i, "#00")

The # means optionally a digit (i.e. present only if there are that many digits in i), 0 means definitely a digit, whereby leading zeros are used if i hasn't got enough digits.

vba excel for-loop

Concatenate with a leading series of zeroes and peel off as many digits from the right-hand side as you need.

animal = "sinani-" & Right("00" & i, 2)'alternate for many leading zeroes (e.g. DUNS number)animal = "sinani-" & Right(String(9, "0") & i, 9)

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last