Can I limit a cell to 2 characters?
 

Is there a way in Excel to limit the number of characters in a cell?

Thanks
Frank

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

You can do it directly, using Data -- Validation, and choosing text length.

"David McRitchie" wrote:

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