your right about the list function, validation via a named array.

That is the issue.

With the format custom 0000, or #### it allows the leading 0, but the
validation doesn't work?

I need a format that will allow all?


--
cclambie
------------------------------------------------------------------------
cclambie's Profile: http://www.excelforum.com/member.php...o&userid=29135
View this thread: http://www.excelforum.com/showthread...hreadid=488546