content center fractions

[fasteddie]

Heellllpppp!!!! I'm trying to modify the content center fasteners so that the "Part Number" field displays a "format" that matches our CAD Standard. I've modified the column property to read
{THREADDESC} & " - " &{NLG}&" in. LONG HEAVY HEX BOLT, SAE GR. 5"
which matches EXCEPT... the parameter {NLG} (nominal length) displays as a decimal, and I need it to display as a fraction. Is there a way to "reformat" this? I tried to make a column with an "If, Then" statement, but it just displayed the statement. What else can I try?? I don't want to go thru each bolt and change it... I'd never get done!!! Thanx.

[amattos]

I had the same issue and I did a workaround that worked for me. It is not perfect but is batter than editing each row at time.

I opened the CC family which I want to change, I also opened a Excel spreadsheet. and did the following:

1- on the CC part table, i created a new column on (NLG_Frac) beside the original NLG

2- I selected all values on the column NLG, copy and past it in the excel spreadsheet.

3- on excel, on the column aside the recently pasted one I created a formula =TRIM(TEXT(B2,"#_??/??"))&CHAR(34) to get the value of culumn B2 , convert it in fractional format, removing extra spaces and adding the character " to the end of the expression.

4- select and copy all values on the new excel column.

5- goto the CC table select the first cell on the NLG_frac Column and paste.. You will see all rolls being filled with the formated values.

6- Now change the CC column Expression to for example {THREADDESC} & " - " &{NLG_FRAC}&" in. LONG HEAVY HEX BOLT, SAE GR. 5" and that's it.

Just to speed up a little I attached a excel sample. I hope this will help you.

Anderson