View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default 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