Exactly 8 numbers

[teiben]

My brain has locked up, I just added a field to an existing db and I need to to hold exactly 8 intergers / numbers; typically the first few numbers are 0's, but the 0 do not display; still using 97, what is the field size/format/ going to be?

Thank you in advance

 

[KeithG]

A true number can not start with a zero. So you are going to have to use a text field. But you say the leading zeros will not be displayed so it is not a mandatory 8 digits, correct?