Formula result to display fraction of an inch

Silverhorne

New Member
Joined
Feb 21, 2015
Messages
20
Office Version
365, 2019
Platform
Windows
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

Well-known Member
Joined
Dec 30, 2008
Messages
7,452
Office Version
2019
Platform
Windows
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

New Member
Joined
Feb 21, 2015
Messages
20
Office Version
365, 2019
Platform
Windows
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.
 

Forum statistics

Threads
1,085,831
Messages
5,386,205
Members
401,984
Latest member
BettaJ

Some videos you may like

This Week's Hot Topics

Top