I just tried your example, and found that if I enter the information as
text (with a leading apostrophe) it works just fine. It also works if
you format the cells as text. But then you'll need to find a way to
insert the appropriate number of leading zeroes. I'll putz around and
see if I can come up with something.


--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557
View this thread: http://www.excelforum.com/showthread...hreadid=502145