Auto fill column with sequential numbers with decimals

  • Thread starter Thread starter Dogstar
  • Start date Start date
D

Dogstar

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.
 
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.
 
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.
 
Back
Top