| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defining character limits
I am trying limit the number of characters allowed in a specific range. I
have several columns, each with a different limit. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defining character limits
Hilight the range... then go to
Date ---- Validation Then change the drop down to "Text Length" Then change the new drop down to Maximum Then type in the maximum number of characters you want to allow. You can then change the error messages that either warn or completely stop people from entering data that is too long. "Steelsilk" wrote: I am trying limit the number of characters allowed in a specific range. I have several columns, each with a different limit. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Defining character limits
Thank you. I knew I had done this before but I couldn't remember how.
"AKphidelt" wrote: Hilight the range... then go to Date ---- Validation Then change the drop down to "Text Length" Then change the new drop down to Maximum Then type in the maximum number of characters you want to allow. You can then change the error messages that either warn or completely stop people from entering data that is too long. "Steelsilk" wrote: I am trying limit the number of characters allowed in a specific range. I have several columns, each with a different limit. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| Defining cell with only through 1 - 32 | New Users to Excel | |||
| Name Defining | Excel Discussion (Misc queries) | |||
| Defining | Excel Discussion (Misc queries) | |||
Hybrid Mode
