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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!