Validation checks
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Validation checks

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    When putting validation checks on cells, is there a way of specifying a certain number of digits (for example, for a phone number)?

    Cheers

    s=t=i=f=f=r=i=m=p=e=t

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-14 07:00, stiffrimpet wrote:
    When putting validation checks on cells, is there a way of specifying a certain number of digits (for example, for a phone number)?

    Cheers

    s=t=i=f=f=r=i=m=p=e=t
    Try text length

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    To add a bit more detail to Brian's reply...
    We are assuming that you are using 'Data Validation'?
    If so, you will notice a combobox with the label 'Allow'.
    One of the options which you can allow is 'Text Length'.
    You may set a minimum or maximum for data entered...
    However, this setting will not differentiate between numbers and text strings.
    There are other ways of forcing exact masks of data entry if you need them directly in your cells or in a form.
    There also may be other ways which I am not aware of.
    Tom

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com