| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increment column values | Excel Discussion (Misc queries) | |||
| Increment/Increment letter in alphabetical order | Excel Programming | |||
| Auto-increment cell values by one | Excel Worksheet Functions | |||
| Spinner control to increment percentages | Excel Discussion (Misc queries) | |||
| How do I increment or decrement values in a column? | New Users to Excel | |||
Linear Mode
