Formula problem

M

Micos3

Hello,
I'm having problem with formula given here :), this formula makes the number 0000 start to 0001 and so on, the problem is that if i'm in cell 264 f.e. but i want to start sequence with number 4704 it gives me more than the 4 number that i have formated for.
="10.01."&TEXT(ROW();"0000")&".00"
What can i do? cos this do exactly what i want but if i fallow the row number, with low numbers continues to do what i want but with higher......

Thank u all
 
P

Peo Sjoblom

You can steer row with ROW(1:1) or anything you will put there and it will
start
to count from there so if you want to start with ROW(264:264) you can do
that
without having to use that particular row

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Micos3 said:
Hello,
I'm having problem with formula given here :), this formula makes the
Click to expand...
number 0000 start to 0001 and so on, the problem is that if i'm in cell 264
f.e. but i want to start sequence with number 4704 it gives me more than the
4 number that i have formated for.
="10.01."&TEXT(ROW();"0000")&".00"
What can i do? cos this do exactly what i want but if i fallow the row
Click to expand...
number, with low numbers continues to do what i want but with higher......
 
M

Micos3

Thanks it really worked :)

But now i have new problem :(
I in this same code i discover that i want it to change the last 2 fixed numbers, depending of the termination of the product that is something like:
Puxador 4041.111 f.e., with words and numbers,
With if i guess that is the way but how will my formula with if recognize the numbers? Because if it recognize and analyses the numbers i guess it will be a question of if's!!
Thanks for all support :)


"Peo Sjoblom" escreveu:
 
Top