# Converting a fraction to text

#### dstetar

##### New Member
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?

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### dstetar

##### New Member
I have found the answer to my question I neded to replace "0 0/0" with "0 #/#" Thank you everyone for reading and I hope this helps someone in the future.

Replies
1
Views
104
Replies
4
Views
642
Replies
7
Views
133
Replies
3
Views
220
Replies
14
Views
348

1,195,635
Messages
6,010,831
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back