Hello,

I am using Excel 2007 I am trying to use the combo box - form control. I
have the input range in a different sheet A1:B200 showing General Ledger
Number and Description. What I want the user to see is the General Ledger
number and description, but only show the account number when the user's
make their selection. Currently I am only seeing the General Ledger Number
when I am looking for a number. How do I do that?
For example:

GL Number Account Description
4550 Sales TMA
I want to see both when trying to make a selection

I just want to see only after selection has been made - 4550.

Thank you in advance.