J
JTEFUN
I'm trying to format a column to only allow 7 characters and it's still not
working, can anyone help me?
working, can anyone help me?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
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
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\)
Assuming column is column A, highlight column (or range)
You should also Format the column as Text so as to allow entries of numbers
with leading zeroes (such as, 0001234).
Rick
Data=>Validation
Allow: Custom
Formula: =LEN(A1)=7
This will allow only a length of 7 (no more/no less!)
You should also Format the column as Text so as to allow entries of numbers
with leading zeroes (such as, 0001234).
Rick
T
Toppers
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