I start with a value of -1 in cell A1 of a worksheet. In
cell A2 I enter the formula =A1+0.1

I repeat the formula downwards. At cell A11 (where I
should read 0), I find an approximation -1.4E-16

Changing the formula to =(A1*10+1)/10 (which is basically
the same) eliminates the problem.

Can this type of problem be avoided through a setup option?