Spinner Increment Values

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top