I’m trying to create a decision making tool that uses a slider control to
change a cost per unit field. I used a scroll bar from the Forms toolbar.
However, this control is not able to increment decimal values. Because I am
using currency, I need .01 detail, however, any decimal value in the
‘Incremental change’ field in the ‘Control’ tab of the ‘format control’ for
the slider is replaced with ‘0’. I’ve currently linked the control to
another cell and the relevant cell has a ‘/100’ formula, but now my users
can’t type a value directly. I’d appreciate any help. Thanks.
Bookmarks