This may be a simple question but one I am stuck on. I am using Excel 2007 and windows 7. I have a column of sizes such as 9 1/4", 9 1/2", 14", 18", 18 1/2". These cells have been cusome formated so that when I enter the decimal number 9.25 it displays as 9 1/2". this all works great. Now I have to take this colum and several other and put them together to make a statent using the & symbol ina formula so thay all add together.
=(Beam!$C$11&" "&TEXT(Beam!$D$11,"0 0/0")&"'' x "&TEXT(Beam!$F$11,"0 0/0")&"'' x "&Beam!$K$11&" - "&Beam!$L$11&" "&Beam!$M$11&", "&Beam!$N$11)
which produces the folowing ina cell
1 Ply 1 3/4'' x 14 0/1'' x 4'-0'' - 1.9E 2650Fb LVL beam, Wall header
The problem I am having is that inusing the TEXT function as shown above breaks down (as n the bold part of the statment)
when the original number did not have a fraction. is there a way to format the TEXT function so that it will only show the 0/0 when there is decimal or is there a better way todo this?
=(Beam!$C$11&" "&TEXT(Beam!$D$11,"0 0/0")&"'' x "&TEXT(Beam!$F$11,"0 0/0")&"'' x "&Beam!$K$11&" - "&Beam!$L$11&" "&Beam!$M$11&", "&Beam!$N$11)
which produces the folowing ina cell
1 Ply 1 3/4'' x 14 0/1'' x 4'-0'' - 1.9E 2650Fb LVL beam, Wall header
The problem I am having is that inusing the TEXT function as shown above breaks down (as n the bold part of the statment)
when the original number did not have a fraction. is there a way to format the TEXT function so that it will only show the 0/0 when there is decimal or is there a better way todo this?