I have an form (Userform1) with a dropdown list. I want the user to select an inflation rate; the dropdown lists is therefore populated with a named range in another sheet. The values in this named ranged are formatted as percentages (e.g., 1.0%, 1.1%, 1.2%, 1.3%, etc., with the range from 0.1% to 10.0%). When the user clicks on the dropdown arrow, the values are displayed properly, however, after the user makes a selection, the value is displayed as a decimal, not a percent. In other words, if the user selects "3.0%" the value is displayed as "0.03." I want the field to reflect 3.0%.
I am at a loss as to how to correct this. Any help would be appreciated.
[TABLE="width: 99"]
<tbody>[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
I am at a loss as to how to correct this. Any help would be appreciated.
[TABLE="width: 99"]
<tbody>[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]