View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.