Convert decimal to text fraction

  • I enter data as a decimal. Like 20.25
    I would like to covert that to 20 1/4 in text form so I can copy and add it to the description in a plywood cut program.
    I can change the format to factions in Excel, but when I copy and paste it reverts back to decimal. The most would have 3 decimals like .125

  • Re: Convert decimal to text fraction


    See if this is something you can use.


    Highlight A1:A6 before running the macro.


    Here's the code, maybe not the best, but it seems to work.

    Files

    • JohnDrew.xlsm

      (18.4 kB, downloaded 73 times, last: )

    Bruce :cool: