View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Jim S[_3_] Jim S[_3_] is offline
external usenet poster
 
Posts: 26
Default Is it possible to do this?

It only works up to 2.9 than it changes to 3.0, 3.1,..,3.9 etc, than it
changes to 4.0, 4.1, etc.

I would like to be able to copy down to 2.1 to 2.191 or higher, than switch
to the next set of numbers such as 3.0 to 3.109 or what ever numbers i would
like at that point.



"Eduardo" wrote:

HI,
let's say that 2.1 is in A2 in A3 enter

=A2+0.1

Copy this formula down

"Jim S" wrote:

I'm taking column A which has a header, column B has a header. Column A is a
numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should
be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in
Column B.

Column A
2.1
2.2
2.3
2.4
2.5
etc.
on down Column A

Column B
acap
at-echo
at-nbp
at-rtmp
at-zis
auth
etc.

How can I have this auto file down column A with numbers that have decimals?