Character limitations for excel fields
Hi,
If you realy mean characters then
data|validation
Select text length and set your parameters. This does not affect the amount
of numbers in the cell.
If you mean the length of any input then:-
data|validation
Select formula is and enter this
=LEN(A1)<6
This works for numbers and text
Mike
"aspen" wrote:
I need to allow users of a spreadsheet to only be able to type a certain
number of characters in a paricular field. How would I do that?
|