Dear sirs,
Drop down list of names , each name reflecting a number. So that when selecting a name it shows its number. For example, in calculating compound interest, the drop down list of names: Annually, Bi annually, Quarterly, Monthly, Weekly , Daily are reflected in the cell by the numbers 1...