Series Error

[kwilky]

Hi,

Im trying to create a really simple series that literally satrts at 1 (the input value) and subtracts 0.05 until it reaches 0. However when I type in the cell reference -0.05, and drag the autofill option down it doesnt give me 0 instead, -3.21 x10^16.

Any help would be much appreciated

Thanks

Karl

[martindwilson]

try using
=ROUND((A1-0.05),4)
or instead go to tools /options and check "precision as displayed"