Hi Humayaun

This information is not enough. A series can be anything. If you are looking
at 1,2,3.... in ColA cell 1 type 1 and in cell A2 type =A1+1 and copy that
down or even =ROW() will do..Please provide more information regarding what
you are looking at...

PS: Stick on to the same post and keep the continuity. This will help even
other
users who search these forums for information.

If this post helps click Yes
---------------
Jacob Skaria


"Humayaun" wrote:

how to Convert the series to a formula?