|
Formula that regulate rezult exacly in 16 symbols!
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? |
Formula that regulate rezult exacly in 16 symbols!
=A1&REPT("0",16-LEN(A1)-LEN(B1))&B1
Regards, Stefi €˛Lion2004€¯ ezt Ć*rta: 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? |
Formula that regulate rezult exacly in 16 symbols!
Many thanks, it was my first post here and it was exacly right suggestion!
Thanks Stefi! "Stefi" wrote: =A1&REPT("0",16-LEN(A1)-LEN(B1))&B1 Regards, Stefi €˛Lion2004€¯ ezt Ć*rta: 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? |
Formula that regulate rezult exacly in 16 symbols!
You are welcome! Thanks for the feedback!
Stefi €˛Lion2004€¯ ezt Ć*rta: Many thanks, it was my first post here and it was exacly right suggestion! Thanks Stefi! "Stefi" wrote: =A1&REPT("0",16-LEN(A1)-LEN(B1))&B1 Regards, Stefi €˛Lion2004€¯ ezt Ć*rta: 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? |
| All times are GMT +1. The time now is 05:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com