Using a SpinButton with decimal increments

%3CLINGO-SUB%20id%3D%22lingo-sub-1266843%22%20slang%3D%22en-US%22%3EUsing%20a%20SpinButton%20with%20decimal%20increments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266843%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all.%20I%20am%20a%20very%20new%20and%20unexperienced%20user%20when%20it%20comes%20to%20Excel%20(or%20most%20programs%2C%20for%20that%20matter).%20My%20concern%20is%20this%3A%3C%2FP%3E%3CP%3EI%20have%20read%20about%20using%20a%20%22Helper%20Cell%22%20in%20order%20display%20a%20SpinButton's%20value%20as%20a%20decimal%20and%20percentage.%20I'd%20like%20to%20create%20a%20SpinButton%20from%200.00%20to%20100.00%20and%20display%20the%20value%20as%20a%20percentage.%20The%20problem%20that%20I%20encounter%20is%20manually%20inputting%20data%20within%20the%20cell.%3C%2FP%3E%3CP%3ESay%2C%20for%20instance%2C%20I%20would%20like%20to%20type%2050%20in%20the%20cell%20(which%20is%20displayed%20as%20a%20percentage)%20and%20then%20use%20the%20SpinButton%20to%20achieve%20a%20particular%20value%20(i.e.%2C%2052.39%25).%3C%2FP%3E%3CP%3EI%20am%20completely%20lost%20and%20would%20sincerely%20appreciate%20any%20help%20you%20might%20have%20to%20offer.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1266843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1270886%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20a%20SpinButton%20with%20decimal%20increments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1270886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F602149%22%20target%3D%22_blank%22%3E%40Jason_Shuman%3C%2FA%3E%26nbsp%3BSpinners%20don't%20allow%20increments%20lower%20than%201%2C%20so%20you%20can't%20say%20it%20has%20to%20go%20from%200%20to%201%20with%20increments%20of%200.01.%26nbsp%3BPerhaps%20a%20work%20around%20like%20in%20the%20attached%20file%20is%20what%20you%20can%20live%20with.%20The%20spinner%20goes%20from%200%20to%2010000%20with%20increments%20of%201.%3C%2FP%3E%3CP%3EThe%20helper%20cell%20(C1)%20is%20in%20fact%20the%20spinner's%20%22linked%20cell%22.%20Then%20in%20cell%20D1%20there%20is%20a%20formula%20%5B%20%3DC1%2F10000%20%5D%20to%20display%20a%20create%20number%20that%20you%20can%20format%20as%20a%20percentage%20between%200.00%25%20and%20100.00%25.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20start%20the%20spinner%20at%2050%25%2C%20just%20enter%2050%20X%20100%20(this%2C%205000)%20in%20the%20linked%20cell.%20I've%20added%20a%20check%20via%20data%20validation%20that%20accepts%20only%20values%20between%200%20and%2010000.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello all. I am a very new and unexperienced user when it comes to Excel (or most programs, for that matter). My concern is this:

I have read about using a "Helper Cell" in order display a SpinButton's value as a decimal and percentage. I'd like to create a SpinButton from 0.00 to 100.00 and display the value as a percentage. The problem that I encounter is manually inputting data within the cell.

Say, for instance, I would like to type 50 in the cell (which is displayed as a percentage) and then use the SpinButton to achieve a particular value (i.e., 52.39%).

I am completely lost and would sincerely appreciate any help you might have to offer.

Thank you.

1 Reply
Highlighted

@Jason_Shuman Spinners don't allow increments lower than 1, so you can't say it has to go from 0 to 1 with increments of 0.01. Perhaps a work around like in the attached file is what you can live with. The spinner goes from 0 to 10000 with increments of 1.

The helper cell (C1) is in fact the spinner's "linked cell". Then in cell D1 there is a formula [ =C1/10000 ] to display a create number that you can format as a percentage between 0.00% and 100.00%.

 

If you want to start the spinner at 50%, just enter 50 X 100 (this, 5000) in the linked cell. I've added a check via data validation that accepts only values between 0 and 10000.