I'm using the below formula:
=IF(J10="n",(CONCATENATE("id",J21,"_promo",J5,"_front_",L6,".jpg")),"")
In the result, I would like what L6 is to be formatted the same way as L6.
The formula returns:
id49_promoJockeyB2G1Bras_front_38986.jpg
What I would like it to return is:
id49_promoJockeyB2G1Bras_front_200600926.jpg
So how do I put in my formula how I want a number to be formatted?
=IF(J10="n",(CONCATENATE("id",J21,"_promo",J5,"_front_",L6,".jpg")),"")
In the result, I would like what L6 is to be formatted the same way as L6.
The formula returns:
id49_promoJockeyB2G1Bras_front_38986.jpg
What I would like it to return is:
id49_promoJockeyB2G1Bras_front_200600926.jpg
So how do I put in my formula how I want a number to be formatted?