How do I add a add leading zero in a cell in excel

by converting it to a text value.

Not seeing what your data is like. If for instance you want 6 digits then format the cells as "000000" (without the quotes), this will display leading zero's ie: 123: 000123. Otherwise text.