difficult format

M

Micos3

I want to format a code like this: ##.0001.## so then i push it down and gives me 0002 and so on, the other ## r numbers. The problem is that when i do that, it sums in the last two numbers instead of what i want, so i ask if it is possible to format like this: (text)##.(number)0001.(text)## so it guives me the sum of number then do what i want. if it is possible how ca i do that?
Thanks
 
R

RagDyer

You can try this, starting in row 1:

="##."&TEXT(ROW(),"0000")&".##"

You'll have to adjust the "Row()" number when starting in any other row.
For example, to start in row 8, use this:

="##."&TEXT(ROW()-7,"0000")&".##"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I want to format a code like this: ##.0001.## so then i push it down and
gives me 0002 and so on, the other ## r numbers. The problem is that when i
do that, it sums in the last two numbers instead of what i want, so i ask if
it is possible to format like this: (text)##.(number)0001.(text)## so it
guives me the sum of number then do what i want. if it is possible how ca i
do that?
Thanks
 
Top