G
Guest
But what I was really looking for was a way to keep the leading zero(s) for
any length (4, 6, 3, 9, etc). Using this method, I would have to be careful
to reformat cells with numbers less than 5 digits (to avoid having extra
leading zeros at the front). Also the same for numbers of more than 5
digits, as they would still drop leading zeros.
any length (4, 6, 3, 9, etc). Using this method, I would have to be careful
to reformat cells with numbers less than 5 digits (to avoid having extra
leading zeros at the front). Also the same for numbers of more than 5
digits, as they would still drop leading zeros.