Assuming column is column A, highlight column (or range)

Data=Validation

Allow: Custom

Formula: =LEN(A1)=7

This will allow only a length of 7 (no more/no less!)

You can add your own message in "Error Alert"

HTH

"JTEFUN" wrote:

I'm trying to format a column to only allow 7 characters and it's still not
working, can anyone help me?
--
JTEFUN