Create fields in a form with a fixed length

G

Guest

Is it possible to create fields in a form with a fixed length? I tried using
Data -> Validation. This does not work well because the user does not know
the length has been exceeded until exiting the field. For example, I would
like to set a field to a length of 20 characters and prevent the user from
entering any data past the 20th character. I can create borders for the
fields but Excel allows the users to keep typing, and they keep typing.

Thanks
 

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

create fixed length cells & rows in excel as space delimited .prn 1
Fixed Length, Text Formatted 2
save an excel file in fixed length records whose fields are blank 1
Fixed Length 9
Text to column fixed length 6
Fixed Character (alpha) length 5
How do I export an Excel spreadsheet with fixed length rows? 5
How do I export an excel file as fixed length records 2

Top