Can I fix a field length when inputting e.g. 30 characters?

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Can I create a field that stops the person inputting data, into an
excel worksheet, when it reaches 30 characters?

Please advise
Cheers
Colin
 
Hi Colin

You can use Data Validation in the menubar
Choose Text length
 
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

Inputting variable length data - outputting fixed character result 2
I need to have a certain number of characters in a cell 8
Field size for Data Validation Input Message 2
How to limit cell to 30 characters or less 2
Checking & Forcing Data Entry in Cells 1
Create fields in a form with a fixed length 1
Fixed Column Width Export 1
Fixed Length, Text Formatted 2

Back
Top