Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2008
    Location
    Northeast US
    Posts
    81
    Thanks
    10
    Thanked 1 Time in 1 Post

    Lookup with leading zeros (Excel 2003)

    Subject edited by HansV to be less vague than "excel"

    I have a 6-digit field used in a look-up. If I type in leading zeros, no value is found from the look-up. How can I accomodate users typing in just the number (as 6543) which works, and users typing in the number as a 6-digit number (as 006543) which doesn't work.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup with leading zeros (Excel 2003)

    Welcome to Woody's Lounge!

    Could you attach a small sample workbook (max. 100 KB) to a reply, so that we have an idea what you're working with and how the formulas that you have operate? Thanks in advance.

  3. #3
    Star Lounger
    Join Date
    Nov 2008
    Location
    Northeast US
    Posts
    81
    Thanks
    10
    Thanked 1 Time in 1 Post

    Re: Lookup with leading zeros (Excel 2003)

    My apologies for the vague subject. Please forgive, I'm new! Also found that I do not have a problem with leading zeros; it was other formatting whichI have corrected. I thank you for your speedy response.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup with leading zeros (Excel 2003)

    No problem!

    Don't hesitate to post again if you have other questions.

Posting Permissions

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