G Guest Aug 3, 2006 #1 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?
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?
G Guest Aug 3, 2006 #2 Type a leading apostrophe before the leading zero.......this will set the cell as TEXT format. Vaya con Dios, Chuck, CABGx3
Type a leading apostrophe before the leading zero.......this will set the cell as TEXT format. Vaya con Dios, Chuck, CABGx3
S SteveW Aug 8, 2006 #3 If you want the numbers to be treated as numbers not text, format the cell first to have custom format of 00000
If you want the numbers to be treated as numbers not text, format the cell first to have custom format of 00000