Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2001
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Input Mask (Excel 2000 9.0.6926-SP-3)

    Is there a way to limit the data entry for a column to a certain format? The format is 10 numbers, a dash, a letter. For example, 1234567899-T could be an entry. Is this possible?

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Input Mask (Excel 2000 9.0.6926-SP-3)

    Ass ume the cell is A1
    Select A1
    Data - validation
    Allow: Custom
    Formula:
    =AND(NOT(ISERROR(VALUE(LEFT(A1,10)))),MID(A1,11,1) ="-",CODE(RIGHT(UPPER(A1),1))>=65,CODE(RIGHT(UPPER(A1 ),1))<=90)
    <ok>

    Steve

Posting Permissions

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