G Guest Jul 3, 2007 #1 I'm trying to format a column to only allow 7 characters and it's still not working, can anyone help me?
I'm trying to format a column to only allow 7 characters and it's still not working, can anyone help me?
G Guest Jul 3, 2007 #2 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
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
R Rick Rothstein \(MVP - VB\) Jul 3, 2007 #3 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!) Click to expand... You should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick
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!) Click to expand... You should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick
G Guest Jul 3, 2007 #4 Good point ... thanks! Rick Rothstein (MVP - VB) said: You should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick Click to expand...
Good point ... thanks! Rick Rothstein (MVP - VB) said: You should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick Click to expand...
