| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROBLEMS WITH FORMATING COLUMNS
I'm trying to format a column to only allow 7 characters and it's still not
working, can anyone help me? -- JTEFUN |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PROBLEMS WITH FORMATING COLUMNS
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PROBLEMS WITH FORMATING COLUMNS
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 should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PROBLEMS WITH FORMATING COLUMNS
Good point ... thanks!
"Rick Rothstein (MVP - VB)" wrote: 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 should also Format the column as Text so as to allow entries of numbers with leading zeroes (such as, 0001234). Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMATING COLUMNS..... HELP | New Users to Excel | |||
| date formating problems | Excel Discussion (Misc queries) | |||
| formating numbers to text in columns | Excel Discussion (Misc queries) | |||
| Cell formating and Rolling columns | Excel Discussion (Misc queries) | |||
| Formating columns | Excel Discussion (Misc queries) | |||
Linear Mode
