Thread: Display fraction in excel 2003

  1. #1
    SAMARAS std10093's Avatar
    Join Date
    Jan 2011
    Location
    Nice, France
    Posts
    2,694

    Display fraction in excel 2003

    Can I display a fraction in excel? I have searched and asked but nobody had a good answer.

    I want the fraction to be displayed like it does in Latex for example, when you write
    Code:
    $\frac{2}{4}$
    Code - functions and small libraries I use


    It’s 2014 and I still use printf() for debugging.


    "Programs must be written for people to read, and only incidentally for machines to execute. " —Harold Abelson

  2. #2
    Registered User
    Join Date
    Jun 2011
    Posts
    4,513
    If it's available with your install, you could try something like:

    Insert -> Object...
    Microsoft Equation 3.0

  3. #3
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,079
    As far as I know Excel doesn't support formatted equations directly in cells. The best you can do is create an embedded equation object which will follow whatever cell it's hovering over should you want to move it around or copy/paste it. It can't be used in formulas, however.

    This is the best I could find on various ways to insert a fraction into Excel, however, none of the choices leave you with anything functional where the operands can be functions or references or the result can be used as a reference.
    Sent from my iPad®

  4. #4
    SAMARAS std10093's Avatar
    Join Date
    Jan 2011
    Location
    Nice, France
    Posts
    2,694
    Both replies do not work on Excel 2003. What you are saying can not be found in Excel 2003 (at least not from me).
    Code - functions and small libraries I use


    It’s 2014 and I still use printf() for debugging.


    "Programs must be written for people to read, and only incidentally for machines to execute. " —Harold Abelson

  5. #5
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,079
    It's an additional install, I suppose where ever you're using Excel, it doesn't support it. In saying that, I guess it's not a great method as it wouldn't be a portable spreadsheet. However, just to be certain you don't support it, below is another microsoft document that claims to apply to Excel 2003 using Microsoft Equation 3.0

    Insert an equation with Equation Editor - Excel - Office.com

    It also explains how to install Microsoft Equation 3.0 if you have installation rights on the computer you're using.

    Again, I fully recognize that this isn't necessarily useful... it's just that short of this, I'm pretty certain there is no native support for fractions in Excel 2003.
    Sent from my iPad®

  6. #6
    SAMARAS std10093's Avatar
    Join Date
    Jan 2011
    Location
    Nice, France
    Posts
    2,694
    I see, thanks, but no. I will suggest my father do this at work (there he has excel 2007).

    Ok I will confess, I tried to change the program, but I did some settings wrong, so when the "installation" was at 90% (pretty much), I cancelled it, but it just died and did not move. So, I had to restart the laptop. Then, everything of the office, but the excel was uninstalled :P (I am not going to install again, until I will need Word ;p )
    Last edited by std10093; 07-09-2013 at 07:56 PM.
    Code - functions and small libraries I use


    It’s 2014 and I still use printf() for debugging.


    "Programs must be written for people to read, and only incidentally for machines to execute. " —Harold Abelson

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Replies: 1
    Last Post: 05-29-2010, 05:24 AM
  2. Replies: 18
    Last Post: 03-26-2008, 09:01 AM
  3. cout fraction display
    By CheyenneWay in forum C++ Programming
    Replies: 7
    Last Post: 05-07-2004, 09:17 AM
  4. Connect 2 domains together (with Windows 2003 and Exchange 2003)?!?!??
    By gicio in forum Networking/Device Communication
    Replies: 2
    Last Post: 09-01-2003, 07:02 PM
  5. Replies: 0
    Last Post: 08-21-2003, 10:40 AM