You would need to enter the data as text. Numbers are stored without
leading zeroes.
You could, of course, use =LEN(TEXT(A2,"00000")) That will return 5 for
integers up to and including 5 digits, but will allow numbers longer than 5
digits to be counted as longer.
--
David Biddulph

"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!