EXCEL
 

I would like the word YES to appear in a drop down box but its 'value' to
equal 100%.

EXCEL
 

On Mar 30, 1:30*pm, Aspen Farms <Aspen
wrote:
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