Hello Excel experts,

I am using Excel Solver and the parameters to be changed is the Month (so an integer, and a non integer values would be interpretated as days, which is not allowed in my case). I use Tolerance at 0.1% and if I put the solver in 'Show Iteration Results' mode, I see the value (which I declared as integer) being changed as a real (the month becomes for instance 11.00003, while I would like to see 10, 11, 12).

Any help. Thanks for your help on this. I am trying to use Solver to see when (which month and year) a particular sundial is best showing the time.

Thanks all the best,


Victor

P.S. WIndows XP
excel 2003