Site language

Format Numbers as Text in a Drop Down List in Excel

Let your friends enjoy it also!

Add it to your website



Link to this



Embed code

1920x1080

1280x720

854x480

640x360

426x240







Responsive embed

Include this script into your page along with the iframe for a responsive media embed

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 numberRead More:trumpexcel.com/format-numbers-as-text-excel/Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - www.youtube.com/c/trumpexcelThis YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.You can find a lot of useful Excel resources on the following site: trumpexcel.com/#Excel #ExcelTips #ExcelTutorial