| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a cell allow only 24 alpha/num. char.to be entered
I have a field that will only take 24 alpha/num. char.. How can I limit data
entered into a cell to 24 char. without having to count char. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I make a cell allow only 24 alpha/num. char.to be entered
Fred,
Select the cell, choose DAta / Validation... Under "allow" choose "Text lenght" and the "equal to" and 24.... HTH, Bernie MS Excel MVP "Fred@JFK" wrote in message ... I have a field that will only take 24 alpha/num. char.. How can I limit data entered into a cell to 24 char. without having to count char. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula with alpha char in cell | Excel Discussion (Misc queries) | |||
| Get "####" when use alpha char in a cell referenced by a formula | Excel Worksheet Functions | |||
| WHY: Jump to other cell when First char entered is upper case (2007) | Setting up and Configuration of Excel | |||
| How do I make a cell increase by 40% when a number is entered | New Users to Excel | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Hybrid Mode
