Zeros are different, in that 0100 is still only 100 - but you CAN do it
with formatting the cells - in this example, format the cells as a
custom type 0000 - this will force Excel to display 4 digits -
obviously extend this formatting as necessary for the number of digits
you need to see!