Add leading zeroes/0’s to existing Excel values to certain length September 28, 2022 by Tarik =TEXT(A1,"0000") However the TEXT function is able to do other fancy stuff like date formating, aswell.