I would like the word YES to appear in a drop down box but its 'value' to
equal 100%.
In cell A1, change the formatting to [=1] "YES"; 0%
then, key in 1 in cell A1, it'll appear "YES"
select the cell(s) u wanted the drop down list to appear,
click data> data validation> allow: list> source: =$A$1
when u select the "YES" in the drop down list, it'll actually be 1
if u still want the cell(s) to appear as "YES", change the formatting
to [=1] "YES"; 0%
if u want more items in the drop down list, i.e. percentages ranging
from 0% to 100%
enter the numbers under the cell A1, i.e. A2:A10
change ur source accordingly to i.e. =$A$1:$A$10
