By checking the length of the cell
=LEN(A1)=2
in your custom validation.
Look for Data Validation on Debra Dalgleish's site.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Frankc" wrote in message ...
Is there a way in Excel to limit the number of characters in a cell?
Thanks
Frank