=TEXTJOIN: Not Returning Text

[Alvin_Gregorio]

Hello Everyone,

I am just now learning about the TEXTJOIN function.
I have entered my argument seemingly correctly, as it appears correct in the Function Arguments window.
But it is not appearing correctly in the worksheet cell.

In the attached file, Cell B27 is a TEXTJOIN(...)

Can anyone review and ascertain what the issue is?

Thank you, Alvin

[#2 · Accepted solution]

Change the cell format from Text to General. Then press F2 and ENTER.

[#3]

Thank You. That works.
I wish I knew why. But Thanks Detlef. -Alvin