How to display a numeric field showing all 5 characters.
Format the cell as Text. Then anything entered in the cell will
display as typed.
Or use the custom format 00000 if the number must remain as a number.
Since it's a 5-digit code, you could also use the ZIP Code format under
Special in the Format list.
|