View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Is it possible to do this?

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?