Use a helper cell to do the math.

Linked cell is A1

In B1 enter =A1*.25

B1 becomes your working cell for the analysis.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 11:43:01 -0700, srpettew
wrote:

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.