Using VBA to Force Superscript and Subscript in Excel Text Cell RRS feed

  • Question

  • I am using decimal numbers to be able to sort correctly in Excel; however I want to have a column where they are displayed as fractions.  I have made a function to convert them to fractions as text ( 1.625 converts to "1 5/8 dia.").  I would like to make the 5 superscript and the 8 subscript.  I can do this manually by highlighting the number and formatting, but I would like to do this in code.
    Wednesday, May 27, 2009 2:44 AM