Percent Format

[IvorTollah]

Hi, I have a cell that is formatted as "0%". The cell has an associated spin button ActiveX Control that increases or decreases the applicable % in the cell. The settings for the spinner are:

Current Value 1
Minimum Value 1
Maximum Value 10
Incremental Change 1

The current value which has been manually entered displays as "1%", when I increase it using the spinner control it changes to 200%.

Excel doesn't recognise an integer below 1 so I can't change the incremental change value to 0.1, it just defaults to 0 if I do. I've attached a couple of screen shots of what it is doing.

I've seen this before and I know there is a simple fix for this, but I just can't remember what it is.

Any help much appreciated.

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[IvorTollah]

Yes! This works perfectly thanks. I hadn't thought to include an interim linked cell that you can then link in turn to the cell that has the % value in it. I knew there was an easy fix, thanks very much.