Thank you Peo Sjoblm

every code is working for me.. =IF(LEN(B1)0,ROW(),"")

can help me to say how to add auto number of rows by selecting some rows
which I need to number.. I've 6000 rows.. But they will be numbered by
selecting 200 rows or 300 rows. After 200 they will be counted or number from
1. Is there any way cell selection with mouse and number them?

"Peo Sjoblom" wrote:

It certainly works for me, once can of course change it to either text or
numbers

=IF(LEN(B1)0,ROW(),"")



--


Regards,


Peo Sjoblom




"Robi" wrote in message
...
Hi I'm using excel 2007 ..

I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")

but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")

is there anything different for 2007