Hi
I have numerious worksheets with tons of cells diplaying numbers as Fractions (Using Fraction Format and Macro to round the fractions to base 32). However these fractions are shown as numbers with decimals in the formula bar. I need these fractions to be seen as fractions in the formula bar. Is there a way I can overcome this problem?
Thanks and regards
KShora
Hi - I have been using Alt 0188 for 1/4. I can not find what the symbol for 1/8 and 3/8 is. Does anyone know?
Thanks! Karen
hi
using excel 2007 i am a noob got the basics i am stuck as to which way if at all possible can excel convert fractions to decimals
eg: 2/1 7/2 9/4 to 3.1 3.7 etc
or could i use fractions in an equation when i try it just keeps converting it to date format
any help if this is possible much appreciated
regards
andrew
Hi Guys,
Is there a way to identify what is causing a particular file to be quite so large, I ask because I get sent a template file of 20mb+ and there are only 6 tabs each with only up to row 400 populated?
Following on from this, would there be a way to reduce the file size? I have tried clearing all contents from the blank cells but that did not seem to make much difference. Can lookup formulas etc cause such a large file then?
Sorry its bit of a general & vague question but your help is very much appreciated.
Ming
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 same horizontal level. I can't seem to show it in this text editor, but if you go into MS Word and type 11 space 3/4 you'll get exactly what I want, but its in Word not Excel. When I copy/paste the text from Word to Excel it display exactly as I want it BUT the 3/4 is inserted as a symbol not as text or a number.
Any help is appreciated
Hi All,
I'm trying to sum fractions (#/#) to get an overall percentage, and am having some trouble with it.
Here's a quick example:
Row 1 2006 2007 2008 2009 | (desired outcome)
Row 2 0/1 0/0 1/1 0/1 | 1/3
Row 3 0/0 0/0 0/0 0/1 | 0/1
Row 4 1/1 1/1 1/1 1/1 | 4/4
Row 5 0/1 0/1 0/1 0/1 | 0/4
Basically, I am trying to calculate participation (numerator) over whether they had the opportunity to participate (denominator). The column above, "desired outcome" is what I want these fractions to add up as (but am currently having trouble with). Basically, I would like to separately sum both numerators and denominators as an aggregate fraction (percentage would work, too). Similar to a basketball player's shooting percentage over the course of different games. The COUNT and SUM functions have been useless thus far.
Thanks!!
OK I got my problem sorted about my league table not updating after putting in my results now was wondering how I go about reducing the number of teams in a league as I want to use the same template for multiple countries leagues.
For instance say instead of 20 teams I wanted to reduce it to 12 is this easy to achieve?
Why does Excel 2007 change SOME of my cell entries from the decimals I enter (and want to keep) to fractions? In one column I have a mixture of results, all with the same value (9.5 and 9 1/2). It is not a column-width problem.
A little bit of searching on the site didn't lead to an answer to our specific question. We have a largish 2007 xlsx from which we deleted large chunks of validation and formatting which were no longer needed. After a save (even a "save as" to a new file), the file size did not change! Any idea of what's going on here or what we could do to reduce the size of the file? Thanks in advance!
eg. 1/1 would become Jan. 1. This comes up when I copy stats from a fantasy
baseball website into excel. How many stolen bases the player has, say he
was 1/2, would become a date.
Thanks in advance for your help, Ted.
