Results 1 to 8 of 8

Problems creating a dropdown box (data validation)...

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2009
    Location
    London
    MS-Off Ver
    Excel 2002
    Posts
    9

    Problems creating a dropdown box (data validation)...

    We've got a dropdown box (data validation - list) which is picking up data from a specific column. The data in the column is in the following format:

    1 Sales
    2 Contracts
    18 Opening Stock
    27 Purchase
    etc

    When we select an entry from the dropdown box the cell obviously displays both the number and the text description to the right.

    What we need it to do is just display the number after selecting an item from the list. The text is descriptive and to make it easier for users.

    Is there a way of configuring the dropdown box (or another way) so that say if a user selects "1 Sales" from the dropdown it just displays "1" in the cell.

    thanks in advance.
    Last edited by BadBoy House; 04-09-2009 at 08:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1