number input
 

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?

number input
 

Type a leading apostrophe before the leading zero.......this will set the
cell as TEXT format.

Vaya con Dios,
Chuck, CABGx3



"dennisp" wrote:

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?

number input
 

If you want the numbers to be treated as numbers not text,
format the cell first to have custom format of 00000


On Thu, 03 Aug 2006 17:10:02 +0100, dennisp
wrote:

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?



--
Steve (3)