Auto number in octals

[meetarun007]

Hi to all,

pardon me if i'm posting in wrong section.

I need autonumber in octal format.

i.e,.
0.0,
0.1,
0.2
.
.
.
0.8,
1.0,
1.1
1.2,
.
.
1.8,
2.0,
2.1... But in autonumbering it is coming in decimal format.

pl help how to get that in octal format...

 

[mikerickson]

Put this in a cell and drag downwards
=REPLACE(DEC2OCT(ROW(A1)-1, 2), 2, 0, ".")

 

[meetarun007]

Its WORKING FINE...thxxx....
can u pl tell me what text i should put if i want to start in between...
example ...
15.0
15.1
.
.
.
15.7
16.0
.
and so on...
Thanks in advance

 

[mikerickson]

Adjust the row of this cell to control the initial value
=REPLACE(DEC2OCT(ROW(A104)-1, 2), 2, 0, ".")

 

[meetarun007]

thanks....
Problem solved..