Auto fill column with sequential numbers with decimals

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.
 
M

Mike H

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.
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top