ExcelBanter - Spinner Button - Incremental Change

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Spinner Button - Incremental Change (https://www.excelbanter.com/excel-discussion-misc-queries/34040-spinner-button-incremental-change.html)

Anauna

Spinner Button - Incremental Change

Hello,

Currently the Spinner button incremental change apparently only accepts
whole numbers. I need to set it to thousandths (.01). Is this possible?
--
Thank-you and all suggestions are appreciated.

Bernard Liengme

Cheat!
Link spinner to E6 and in D6 use =E6/1000. \Now D6 changes by 0.001
(thousandth) - use /100 for changes by 0.01 (hundredths)
Maybe drag spinner over E6 to hid it.
Best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Anauna" wrote in message
...
Hello,

Currently the Spinner button incremental change apparently only accepts
whole numbers. I need to set it to thousandths (.01). Is this possible?
--
Thank-you and all suggestions are appreciated.

All times are GMT +1. The time now is 08:58 AM.