Possible bug in Excel?

[Dreamer]

If you type 5 in a cell and drag across using the little black cross
cursor you will get a row of 5s.
If you highlight a blank cell below it at the same time and drag
across the numbers will increment so you get 5,6,7,8 etc.

If you type 5% and drag across you get a row of 5%s as you would
expect.
However, if you highlight the 5% and the blank cell below then drag
across using the black cross, you get 5%, 105%, 205%, 305% etc.

Is this what you would expect? Doesn't seem right to me........surely
you should get 5%, 6%, 7%, 8% etc?

 

[Pete_UK]

5% is really 0.05, and 105% is 1.05, so the increment is 1 each time -
there is consistency in this (though I wasn't aware of the effect
until you pointed it out).

If Excel gave 5%, 6%, 7% etc as you suggest, then the increment would
be 1/100.

Hope this helps.

Pete

 

[Sandy Mann]

I have never done what you are saying in exactly that way but yes, that is
what I would expect. 5% is a fraction, it is 5/100. By draging on the fill
handle, (the little black cross), you are indexing the numbers by 1. 1 is
100% (ie 100/100) so it indexes by 100% each time.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You can get XL to do what you wanted by putting 5% in one cell, 6% in the
adjacent cell and then dragging on the fill handle to get 5%, 6%, 7%.....

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk