Question

how convert drop down list text format or ms excel formate ?​​

Answer 1

Method 2 – Format Number as Text in the Cell in Excel

Select the cell that has the drop down validation list and press Control + 1 (This opens the Format Cells dialogue box).

Select the Number tab and go to Custom option.

Type [=0]”Not Selected” OR Type 0;0;”Not Selected”.

Click OK.

Answer 2

Answer:

Select a cell where you want to create the drop down list (cell C2 in this example). Go to Data –> Data Tools –> Data Validation. In the Data Validation dialogue box, within the Settings tab, select List as the Validation criteria. As soon as you select List, the source field appears.

hope it helps buddy :)