Convert Decimal To Text in Fraction format

  • I am copying a list of numbers with decimals but formatted to display fractions.


    Example 10.125 shows 10 1/8 when formatted in the cell.


    When I copy and post to my PLYWOOD cut list, it only shows the decimal. I would like it to show 10 1/8 as in the example, when posted.
    I could do it with vertical lookup, but hoping there is an easier solution. I don't use anything less that 1/16

  • Re: Convert Decimal To Text in Fraction format


    Can you not simply apply the same formatting to your PLYWOOD cut list, whatever that is?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why