Formula result to display fraction of an inch

[Silverhorne]

Hello,

This seems like a simple cell format issue but everything I have tried has not worked for me.
I am using Office 365, I have 6 cells merged that display the result of an Index/match formula. This cell is formatted as a fraction but will only display a decimal number.
I would like it to display in proper fractions of an inch. I have tried the same formula in a non-merged cell and got the same result.

I don't think the formulas affect this but here they are anyways:
The formula in the merged cells with the index match that will not display as a fraction:
=IF(ISBLANK(D28),"",IF(INDEX(MASTER!$B$6:$Z$304,MATCH($D28,MASTER!$B$6:$B$304,0),22)="","",CONCATENATE(INDEX(MASTER!$B$6:$Z$304,MATCH($D28,MASTER!$B$6:$B$304,0),22))))

This is the formula in the cell that the above formula pulls from, which does display as a fraction:
{=INDEX(Studs!$E$4:$E$216,MATCH(1,(G6=Studs!$C$4:$C$216)*(H6=Studs!$B$4:$B$216),0))}

Thank you in advance for any help.

 

[jasonb75]

Try removing the concatenate function from your formula, that is causing the result to be returned as text instead of a numeric value, meaning that any numeric formatting applied to the cell will be ignored.

 

[Silverhorne]

Thank you!
Once you said that I looked at what the concatenate was there for and realized I copied that formula from another cell and only removed the second half of the concatenate rather than the whole formula.