Hi Jannie

< I tried copy and paste special to make them values but it's not working. I
had to format the cells

By this do you mean you copied a 'blank' cell, then selected your data, then
paste
special, check 'add' and OK.

This should convert all your data to numbers and then applying the custom
format should put all your leading zeroes in place.

HTH
Martin