excel vba count leading zeroes code example Example: vba leading zeros in string MsgBox format(12,"0000") ' OUTPUT: 0012