fractional display

  1. A

    Formula to use fraction to set levels

    Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...
  2. A

    Fraction Display

    I'm having some rounding issues with fractions. Here is what excel is calculating: -5/16 + 5/7 = 2/5 I'm looking for the answer 45/112 Also, for the value 24.666667 excel is showing 24 2/3. I would like this to show 74/3.
  3. S

    Formating fractions in Excel

    Hi, I know how to use the fraction format, but it displays the fraction as, for example,11 3/4, where the fraction (3/4) is displayed as the same font size as the integer, 11. What I want is for the fraction, 3/4, to be smaller font than the integer, 11, AND that the 3 be above the 4 not on the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top