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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For John, et al. Re Combining Columns (previous post) 4
Zip Code Formatting 8
How to enter zip starting with 0 (zero) 10
Amazon not accepting Visa Credit Card for payment from January 2022 20
selection hanging 2
Entering 16 digit numbers in cell 3
excel does not accept "0" as the first zip code number? 4
Leading Zeros; How to Keep ? 2

Back
Top