Increments less than one in format control box for spinner
 

Use an intermediate cell to calculate the increment then refer to that cell.

For example, A1 is the spinner linked cell. Use B1 to calculate the
increment you want to use:

=A1/10
=A1/4

Then refer to B1 in the formulas that you want to calculate when you click
the spinner.

--
Biff
Microsoft Excel MVP


"srpettew" wrote in message
...
I've added a spinner to my NPV analysis with regards to the discount rate.
What I'd like to do is use increments of .10 or .25 as opposed to just
whole
numbers. Don't understand why this is not a built in feature in the
format
control box. I'm using 2003. Any help is appreciated.