zip code
Posted by agnes on October 22, 2001 2:00 PM
how do you prevent excel from dropping first zero in a series of digits. for example, when using a zip code that begins with zero 04976 reads as 4976. i've already tried formatting with custom settings. nothing works.
Posted by EDDIE G on October 22, 2001 2:25 PM
format the cell as text and it will work.
go to format>cells>text
Posted by Ryan on October 22, 2001 2:28 PM
I just tried it using:
Format Cells -> Number -> Special -> Zip Code
And it worked fine. Try using the built-in function under Special (it has Zip Code and Zip Code plus 4) instead of doing you own custom format. Hope this helps
Posted by Richard S on October 22, 2001 2:28 PM
What did you use with custom format? If you select format 00000, 1 will appear as 00001. The other alternative is use =TEXT(4976,"00000"), then copy and paste values. It will then be stored as text and not a value.
HTH
Richard
Posted by Qroozn on October 22, 2001 2:47 PM
yet another one
put ian apostrophe in fron of the number e.g '0497
Posted by Ian Mac on October 23, 2001 3:16 PM
