#### Silverhorne

##### New Member

- Joined
- Feb 21, 2015

- Messages
- 20

- Office Version
- 365, 2019

- Platform
- Windows

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.