Using TEXTJOIN and making sure reference cell always has two digits

[Nanaia]

I'm trying to use TEXTJOIN to combine two cells (job number and phase number) into one number. The phase number must always be two digits and I know that by using custom formatting I can make it display as two digits. The problem is when using TEXTJOIN it doesn't look at the formatting, it looks at the value. Is there a way to get TEXTJOIN to add a zero before any number lower than ten?
i.e.: P4=47559, R4=09, [ =textjoin(,,P4,R4) ] gives the result as 475599 not 4755909

 

[JamesCanale]

MrExcelPlayground.xlsm
	J
3	5
4	123
5	12305
Sheet30

Cell Formulas
Range	Formula
J5	J5	=VALUE(TEXTJOIN(,TRUE,J4,TEXT(J3,"00")))

 

[Phuoc]

Or try:

=P4&TEXT(R4,"00")

 

[Nanaia]

MrExcelPlayground.xlsm
	J
3	5
4	123
5	12305
Sheet30

Cell Formulas
Range	Formula
J5	J5	=VALUE(TEXTJOIN(,TRUE,J4,TEXT(J3,"00")))

Awesome!! - Thank you!

 

[Phuoc]

Another way:

=P4*100+R4