3 Ways to add a zero in front of a number in Excel. It can be tricky to add a leading zero in Excel without having the zero disappear. Step by step instructions + video tutorial.