custom format does not change what's in cell, if cell was originally a real number say 12 then custom format 000 gives 012 but its still a real number not text "012"