Drop down lists are created with the input data that also resides in the workbook. While in most cases we may want the drop down items to look exactly the same as the input range, in some cases you may want it to look different.
For example, you may want 1 to look TRUE and 0 to look FALSE.
In this video tutorial, I will show you a trick to do this. You will learn how to create a drop-down list in Excel that displays desired text, but when selected, returns a number
Read More:
trumpexcel.com...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Негізгі бет Format Numbers as Text in a Drop Down List in Excel
Пікірлер: 29