cell entry

  • Thread starter Thread starter Tamsin
  • Start date Start date
T

Tamsin

Is there any way to limit the number of characters entered
into a cell. I'd like no more than 5 to be allowed.
 
Hi Tamsin

check out data / validation
choose text & set the settings you require

Cheers
JulieD
 
Hi
the limit is 1024. So you should have no problem to enter
more than 5 (unless there's a cell validation in place)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code character limit with Resize or Transpose or cell? 8
Text Formats 4
Moving extra characters to a new column 12
Code for multiple select of cells 16
string width 8
Data validation, mandatory and restricted field length for excel vbs 10
Cell entry triggers Worksheet_SelectionChange event 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top