Using form controls with scientific notation

[DeaninGA]

Can you control a cells value( scientific notation ) with for example the spin control to scroll for example from

<colgroup><col width="709"></colgroup><tbody>
[TD="class: xl63, width: 709, align: right"]

1.00E+01
1.00e+02
1.00e+e03
etc
​

im using this cell as an input into a much larger set of data that will change as you spin up and down the possible selections but The form control doesnt seem to like scientific notation... Help ??

TY in advance Dean


​

[/TD]

</tbody>