Auto fill column with sequential numbers with decimals
 

Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4

What method works? Can only seem to get sequence on primary number, example:

3.1, 4.1, 5.1

I want the number to the right of the decimal to change.

Auto fill column with sequential numbers with decimals
 

Hi,

Enter 3 in a1
Enter 3.1 in a2

Select both and drag down using the fill handle
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Dogstar" wrote:

Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4

What method works? Can only seem to get sequence on primary number, example:

3.1, 4.1, 5.1

I want the number to the right of the decimal to change.

Auto fill column with sequential numbers with decimals
 

Or,

Enter 3 & 3.1 as before select the range to fill then

Edit|Fill - Series OK

Mike
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Dogstar" wrote:

Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4

What method works? Can only seem to get sequence on primary number, example:

3.1, 4.1, 5.1

I want the number to the right of the decimal to change.