Working with fractions and decimals

[DashboardNovice]

In the attached file, I am starting from column D. The answer I am trying to derive is in column G. Columns E:F shows the value in column D expressed in a different way.

The fractions correspond fractions of a cent. For example, in cell D3, 770.25 cents can be rewritten as $7.70 3/4. Instead of using fourths, I want to use eighths. Therefore E3 can be rewritten as $7.70 6/8. Then ultimately I want the answer in G3 to read the total number of cents in whole numbers (770) and the fractional portion would be represented as an apostrophe followed by the numerator of the fractional part in F3, which in this case is the 6 as in 6/8. So the fractional part would show only the numerator after an apostrophe and leave off the denominator because the denominator is implied (this is how futures quotations are expressed).

I am having trouble working with the decimal/fractional portion of the number. Also I can't figure out how to extract only the numerator.

 

[r2c2]

@DashboardNovice

I think you are mistaken. 770.25 would be 770 2/8 not (770 6/8). So to convert 770.25 in to 770'2 c, you can use below formula.

=INT(D4)&"'"&LEFT(TEXT(MOD(D4,1),"?/8"),1)

Please note that the result of this formula will be text. So you can't use it to sum / average etc.