Forum Discussion
Solved
Leading zeros
Good Morning, I lost my leading 0's on all of my 5 digit product numbers. Is there an If statement that can find anything with a 4 digit number to add a leading 0? Thanks!
- Not sure exactly what you want your end product to look like, do you want it to be all text? Would something like this work? This is unaffected if you convert cell format to text. =IF(LEN(A2)=4,0&A2,A2)
When I try the REPT formula on my end it doesn't change any of the calculations ran off of it.
Hello,
If your data is formatted as text, then DKoontz formula should work.
However, if your data is formatted as a number, then try using a custom number format like "00000" for a 5 digit number with leading zeros.
If your data is formatted as text, then DKoontz formula should work.
However, if your data is formatted as a number, then try using a custom number format like "00000" for a 5 digit number with leading zeros.