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
i.e.: P4=47559, R4=09, [ =textjoin(,,P4,R4) ] gives the result as 475599 not 4755909