Formula that regulate rezult exacly in 16 symbols!

L

Lion2004

I have in cell A1 value 2, in B1 value 1 (it changes), in C1 i have to get
rezult starting from value 2, therefore many zeros and finally value in B1,
it seems to be like 2000000000000001.
If value in B1 is 11, result must be 2000000000000011
If value in B1 is 111, result must be 2000000000000111 and e.t.c.
Rezult must be always 16 digits long!
Can anyone help?
 
L

Lion2004

Many thanks, it was my first post here and it was exacly right suggestion!
Thanks Stefi!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs with different restrictions 1
Can a formula do this? 1
Excel not recognizing formula 1
Formula to copy another cell's contents - Help! 5
how to use pivot data in formula or fuctions? 1
Formula help--Vlookup? 8
Functions 1
pre determine value 4

Top