Spin button up/down increment .01 decimals

[Strugggler]

I could use help with this as I've tried many options that do not work. In Worksheet 'Oct26' in Column D I would like the spin button to link to D11 and spin up and down in .01 increments (returning values in decimals) instead of positive numbers. I have other spin buttons on this worksheet, but once I know the solution for D11 I'll be able to do the rest. Uploaded is a copy of the worksheet and a graphic image. I appreciate any help I can get with this.

[Palmetto]

You can set the Spin_Up or Spin_Down increment like so. Excel will not allow you set it to a decimal value directly in the property window.

Please Login or Register  to view this content.

[MickG]

Hi, Try :-

Please Login or Register  to view this content.

Regards Mick

[Strugggler]

Hm! Thanks guys! Neither suggestion worked for me. I am trying to decrease and increase the value in D11 by .01

I read somewhere before that this could better be done by using a helper cell. Does anyone know how to do that?

[martindwilson]

link it to another cell somewhere say b4 in that cell put 100
change increment to 1
in your cell put =B4/100