Home |
Search |
Today's Posts |
#10
![]() |
|||
|
|||
![]()
Hi Rob,
Another way is to use the Text Length option under Data Validation Settings Allow Text Length Choose the criteria you want Ok. HTH Regards, Howard "abfabrob" wrote in message ... I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I want to limit the number of characters they can use. Can this be done? I have put text wrap on the cell, but it still allows me to enter more information than fits into the box. I want it to stop users entering info when the visible cell is full. Rob, Teesside, UK. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |