How to concatenate to get specific format

[krodriguez]

Any ideas on how to do this?
these are the values I have on these cells:
A1=7100 B1=5 C1=2 D1=0 E1=0 F1=0

In cell G1 above needs to look in this format

7100-05-10-00-000- 0000

<tbody>
</tbody>

Thanks,

 

[Joe4]

=TEXT(A1,"0000") & "-" & TEXT(B1,"00") & "-" & TEXT(C1,"00") & "-" & TEXT(D1,"00") & "-" & TEXT(E1,"0000") & "-" & TEXT(F1,"0000")

Though, I think you may have a typo with C1 (if C1=2, how does that translate to "00"?)

 

[Sharid]

You can try this

=CONCATENATE(A1, L1, "0",B1, L1, "0",C1, L1, "00",D1,L1, "0",E1,"0", F1)

L1 is where I placed the Dash -

 

[Sharid]

Use this one its better than the last one

=CONCATENATE(A3, "-", "0",B3, "-", "0",C3, "-", "00",D3,"-", "0",E3,"0", F3)

the Dash is in the consatente

 

[krodriguez]

Thanks! works fine and yes I did have a typo, good catch! thanks again

 

[Joe4]

You are welcome.