Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Tip: percentages with spinners etc (Excel 2002)

    This is not a question but rather a tip re a workaround to use certain forms (sliders, spinners) with percentages.

    Let's say the cell where you want the resultant percentage to be displayed is cell a1.

    Set the spinner's control link to another cell -- for this example, let it be cell b1 -- and set the range from 0 to 100, with increments of 1.

    Next, format cell b1 to hide the resultant values in it (e.g. make the font white if the cell background is also white). (You might also want to put some vaildation on cell b1 to prevent it from being overtyped. I find that setting the validation to only allow the decimal value of 865486.9873237 or something similar works well.)

    Now enter this formula in cell a1:

    =b1 / 100.

    Lastly, format cell a1 as a percentage.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tip: percentages with spinners etc (Excel 2002)

    Thanks, that is a good tip.

    One minor point: if you set the text color to the same as the background color, the cell contents will normally be invisible, but if you select a range of cells including the linked cell, Excel will show the value in a low-contrast color. If you really want to hide the contents, set the Number format to the custom format <code>;;;</code> (three semicolons after each other with nothing in between); this hides all kinds of values.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Tip: percentages with spinners etc (Excel 2002)

    Thanks Hans, that's a good tip too. By the way, I have it writing from Woody that he's going to triple your salary

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tip: percentages with spinners etc (Excel 2002)

    Wow, thanks! That's going to make a big difference. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •