엑셀 숫자의 시작 부분에 제로 추가
=TEXT(A2,"00000000000")
or format only with
CTRL+1 > Number > Custom > Type > 00000000000
엑셀 기존 값에 선행 0 추가
'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.
excel 에서 숫자 앞에 0 을 추가하는 방법
change the data type input string