Results 1 to 6 of 6

Drop down list that only puts a number in the cell

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Cincinnati, Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Question Drop down list that only puts a number in the cell

    I know how to create a drop down list, but I want to do something a little different and am not sure if it is possible. I would like to have each item of the drop down list numbered and when chosen, only the number is entered in the cell.
    So the drop down list would be something like:

    1. absolutely not
    2. maybe
    3. definitely

    Picking one of these from a drop down list would only put a 1, 2, or 3 in the the cell.

    Is this possible and how?
    Last edited by cinci-hal; 07-20-2017 at 09:43 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro that Puts every Email Address within a Cell into its own separate cell...
    By rjw524 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2016, 10:58 PM
  2. When I CopyFromRecordset a MYSQL CONCAT statement, it puts 256 blank rows into Excel table
    By Coastal_view in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2015, 09:28 AM
  3. Replies: 1
    Last Post: 07-02-2014, 07:10 PM
  4. Lookup Column number in a table based on a cell value
    By electricmice in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-22-2012, 01:08 AM
  5. Pivot table, Automatically puts data in alphabetical
    By Cicada in forum Excel General
    Replies: 6
    Last Post: 09-01-2011, 10:30 AM
  6. Replies: 3
    Last Post: 01-27-2011, 10:02 AM
  7. [SOLVED] Excel puts a 0 at the end of my number
    By Dan Connors in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2005, 04:30 PM

Tags for this Thread

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