Thread: Formula that regulate rezult exacly in 16 symbols!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default 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?
Reply With QuoteReply With Quote