Well, I have set the cells to
displayfractions and it seems to display any number like 1.375 as 1
3/8which is what I want. but it also displays any non integer as
adecimal. i.e. .375 as 0.375... I would like it to be shown
as3/8.

Thanks for your response
and any help youcan lend John

well guys I tried all of those suggestions and none of
themworked... as I've said before I have completely defined a piece
ofsteel with variables and added them to the custom properties..
thenrenamed the cells propriety in exce.lI have tried just about
everyoption in excel that I can think of... Still numbers less than
1are displayed as decimals I sure appreciate all of the
suggestions.check out the jog and let me know if you have any more
ideas. thecolumns to the right of "stock size" are my custom
prop.variables. In the "the stock size" column, I've writtenan "if
statement in excel to pull the values in.=IF(I2=0,"",I2&"''
x"&IF(J2=0,"",J2&"'' x"&IF(G2=0,"",G2&"''
x")))&IF(E2=0,"",E2&"'' x"&IF(F2=0,"",F2&"''
x"&IF(H2=0,"",H2&" x "))) Thanks.

I believe your are not having a problem formatting individual
cellsto display fractions correctly. I think the problem you
arehaving is displaying them in fractions in your
descriptiondisplayed for your stock size column.
Using formulassuch as ="Stock"&"A1&"x"&A2requires
the cell formatting set to "General". Here in lies your
problem. You would like to combinetext format with fraction
formatting. This is done using thetext command in MS Excel.
I have attached an example to showyou how it's done.

The formula I used looks like this:
="Stock"&TEXT(D3,"#??/??")&"x"&TEXT(C3,"#??/??")&
"x"&TEXT(E3,"#??/??")&" LG"

Also, instead of the elaborate IF statements you used in
theprevious post, maybe lookup the ISBLANK() command. This
maymake the formula a little easier to follow.

## Attachments

descriptiondisplayed for your stock size column. Using formulassuch as ="Stock"&"A1&"x"&A2requires the cell formatting set to "General". Here in lies your problem. You would like to combinetext format with fraction formatting. This is done using thetext command in MS Excel. I have attached an example to showyou how it's done.The formula I used looks like this:

="Stock"&TEXT(D3,"#??/??")&"x"&TEXT(C3,"#??/??")& "x"&TEXT(E3,"#??/??")&" LG"

Also, instead of the elaborate IF statements you used in theprevious post, maybe lookup the ISBLANK() command. This maymake the formula a little easier to follow.

## Attachments

You want to display nothing, if the value is Zero. I foundout you can control this with the text command as well:

=TEXT(A1,"# ??/??;;")

This formula will display nothing if the cell is equal to zero. See image below for the use of semicolons in the textcommand.

## Attachments