| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Function that returns symbols as formula result eg up/down arrow? | Excel Worksheet Functions | |||
| can I remove negative symbols without a formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Linear Mode
