Share via

Create a macro to insert fractions

Anonymous
2012-12-02T19:56:23+00:00

I am working in a publisher document that requires fractions other than 1/4; 1/2 or 3/4. Is there a macro to allow me to insert other fractions in my document?

Microsoft 365 and Office | Publisher | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-12-03T06:47:19+00:00

    I recently created an Excel macro that creates AutoCorrect entries for all ˣ⁄₂, ˣ⁄₄, ˣ⁄₈, ˣ⁄₁₆, ˣ⁄₃₂ and ˣ⁄₆₄ fractions from ¹⁄₆₄ to ⁶³⁄₆₄. Once created in Excel, they will be available to all Office programs.

    You can find a copy of the sample workbook with that macro, the helper UDF and an automated removal macro from my SkyDrive here:

    Sixty-Fourth_Fractions.xlsm

                  

    Edit: added image

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2012-12-03T06:29:14+00:00

    I am working in a publisher document that requires fractions other than 1/4; 1/2 or 3/4. Is there a macro to allow me to insert other fractions in my document?

    =============================================

    You can find a few more choices if you go to...Insert / Symbol...

    and open the Subset drop window and choose Number Forms.

    See screenshot:

    Character Map

    http://i49.tinypic.com/2ut4we8.jpg

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-22T16:58:22+00:00

    Jeeped, this is perfect.  I'm fairly unfamiliar with using macros in Excel.  If you would allow me to use this macro, could you explain how I can 'install' it into some of my spreadsheets?  

    Cheers,

    Curtis Manning

    Curtis Manning Design

    Landscape Design/Construction

    0 comments
  2. Anonymous
    2014-03-22T18:16:54+00:00

    Hello Curtis;

    This reply was so well received that I turned it into a local Wiki article. 

    Styled Fractions in Windows

    The article expands on how things are accomplished and how to run the macro to create AutoCorrect entries for any denominator. Once the AutoCorrect entries are created they are available in any Office document or workbook . There are also inctruction on how to remove the AutoCorrect entries.

    If you have trouble post back here or as a comment in the Wiki article and I will try to fill in the blanks.

    0 comments
  3. Anonymous
    2016-01-13T20:25:20+00:00

    Office 2010 does not have the "Subset" shown in the tinypic link.  Please clarify this on *this* page.

    Even better, create an answer for previous versions.  This would be extremely helpful!  Thanks.

    0 comments