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?

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?

Please be a bit more clear as I have never done this before. I need to set a
paramater of no more than 32 charaters to be entered into a field on a
spreadsheet. What is the exact way the formula should read?

"Mike H" wrote:

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?

OK character and NOT the amount of numbers:-

Select your cell then click
Data|Validation
Select 'Text Length'
select 'Less than or equal to"
enter 32
Click OK

Mike

"aspen" wrote:

Please be a bit more clear as I have never done this before. I need to set a
paramater of no more than 32 charaters to be entered into a field on a
spreadsheet. What is the exact way the formula should read?

"Mike H" wrote:

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?

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?

This formula gives me an error message after typing 1 character and I need to
be able to type 32.




"David Biddulph" wrote:

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?

Got it thanks!

"aspen" wrote:

This formula gives me an error message after typing 1 character and I need to
be able to type 32.




"David Biddulph" wrote:

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?

after following your instructions it still only lets me add 15 #'s any #'s
after that show up as zero's?????
--
Tom M


"aspen" wrote:

This formula gives me an error message after typing 1 character and I need to
be able to type 32.




"David Biddulph" wrote:

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?

Excel only keeps track of 15 significant digits.

You can either start your data entry with an apostrophe: '1234123412341234
or
preformat the cell as text.

TOM M wrote:

after following your instructions it still only lets me add 15 #'s any #'s
after that show up as zero's?????
--
Tom M

"aspen" wrote:

This formula gives me an error message after typing 1 character and I need to
be able to type 32.




"David Biddulph" wrote:

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?




--

Dave Peterson

the apostrophe worked... thanks much
--
Tom M


"Dave Peterson" wrote:

Excel only keeps track of 15 significant digits.

You can either start your data entry with an apostrophe: '1234123412341234
or
preformat the cell as text.

TOM M wrote:

after following your instructions it still only lets me add 15 #'s any #'s
after that show up as zero's?????
--
Tom M

"aspen" wrote:

This formula gives me an error message after typing 1 character and I need to
be able to type 32.




"David Biddulph" wrote:

Data/ Validation.
--
David Biddulph

"aspen" wrote in message
...
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?




--

Dave Peterson