add 0 in front of number excel code example

Example 1: excel add leading zeros to existing values

'Three ways to left-pad an existing value with zeros:

'1.) Number Format
Select Cell Range-->Format Cells-->Number-->Custom-->00000
'Use this when it is important to keep the actual values numeric but
'you need padded zeros for display.


'2.) Worksheet Formula:
=TEXT(A1,"00000")
'Use this when it is important to change the actual values to text.


'3.) VBA Function
Function Pad(s$, Optional padChr = "0", Optional num = 5)
    Pad = String(num - Len(s), padChr) & s
End Function
'Use this when it is important to change the actual values to text.

Example 2: how to add 0 in front of number in excel

change the data type input string

Tags:

Vb Example