fixed length string

G

Guest

Hi,
how can I force user to enter a string of fixed length in a cell (eg. 7
characters)?
Thanx

alekmil
 
F

Frank Kabel

Hi
use 'Data - Validation - Custom' and use the following
formula (for cell B1):
=LEN(B1)=7
 
G

Guest

Hi, it helped. Thanx
Where can I find generally on syntax that goes in that custom formula field?
alekmil
 

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

Cut the last 20 characters out of a text string 4
how can I find out number of pages in tab control 1
referencing controls 1
disallow state change of check box 9
How do I check the current value of check box not reffering it by 2
String length 1
function needed 1
not a sigle cell selected 2

Top