number input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Wht is it that Excel does not accept a zero as the first number of a 5 digit
zip code? How do you get Excel to accept it?
 
Type a leading apostrophe before the leading zero.......this will set the
cell as TEXT format.

Vaya con Dios,
Chuck, CABGx3
 
If you want the numbers to be treated as numbers not text,
format the cell first to have custom format of 00000
 
Back
Top