Excel How-to
Keep Leading Zeros in Excel and Google Sheets
Store 001 as text, or pad with TEXT(n,"000"). VALUE and SPLIT turned 001 into 1 in this Google Sheets test; LEN confirmed when the zeros were kept.
#leading-zeros
1 tutorial tagged “leading-zeros”.