Question

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

Answer 1

ANSWER

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.01-Mar-2021