There is no "formula" in the list in the settings tab under data validation.
I am probably doing this wrong! Does it make a difference which version of
Excell I am using? (2000)


"abfabrob" wrote:

Thank you for your help. I will give this a try.

Rob,
Teesside,
UK

"Springbok" wrote:

Sorry, another note... Fiddle about with validation and you'll see that there
are other options available too.

"abfabrob" wrote:

I am creating an application form to be used electronically. I want a
particular cell to be free text, so users can write what they like (ie their
name), but I want to limit the number of characters they can use. Can this be
done?

I have put text wrap on the cell, but it still allows me to enter more
information than fits into the box. I want it to stop users entering info
when the visible cell is full.

Rob,
Teesside,
UK.