Results 1 to 2 of 2

Thread: input masks

  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    26

    Unanswered: input masks

    hi

    does anyone know if it is possible to use "input masks" in excel to restrict user entry like in Access.

    I want to enter 10 didgit account number in the format 1234-56789-0

    thnx
    Beth

  2. #2
    Join Date
    Aug 2003
    Posts
    106
    Just goto Format, Cells. On the Number Tab, select Custom and type into the box on the left

    0000-00000-0

    Press OK

Posting Permissions

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