If you have the cell formatted as Zip Code, why are you checking its length
at all? Wouldn't all your zip codes have to be 5 characters long with that
format? Or are you putting something else besides zip codes in a cell
formatted as Zip Code? If that is what you are doing, then what other
entries can there be?

--
Rick (MVP - Excel)


"Daren" wrote in message
...
Hello,

I have a zip code as 06110 formatted as zip code. I used LEN on that zip
code and it returns a 4 because it's not reading the leading zero. Is
there
a function that will return a value of 5 for a zip code with a leading
zero
and still be able to return a value of 5 for zip codes that have 5 digits?
Thanks!