View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln
 
Posts: n/a
Default 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.