ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spinner Increment Values (https://www.excelbanter.com/excel-programming/378740-spinner-increment-values.html)

Steve

Spinner Increment Values
 
Hi.
I am using a spinner for number input.
Can anyone tell me how I can make the spinner increment decimal values
I.E. 1.15, 60.04 etc

Thank you for all your help in advance
steve

Bob Umlas, Excel MVP

Spinner Increment Values
 
You can't directly, but another cell can have the linked cell to the spinner
divide it by 100. So if the linked cell is B4, and contains 115, then another
cell, say B8, is =B4/100, or 1.15.

"Steve" wrote:

Hi.
I am using a spinner for number input.
Can anyone tell me how I can make the spinner increment decimal values
I.E. 1.15, 60.04 etc

Thank you for all your help in advance
steve



All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com