How can I display unreduced (3/9 not 1/3) fractions in Excel? I want to see the actual numbers I am working with, not the reduced fraction that Excel defaults to. Any help at all would be appreciated. Thanks!
Agree with calcacuccia: It does not seem possible to enter a fraction without Excel reducing it to lowest possible terms automatically - not whilst retaining numeric functionality anyway.
Dave
0
deyottAuthor Commented:
Thanks for the info. That is what I have found to be true, I just wanted to see if anyone else knew of something different.
(Of course this applies for a fraction entered in cell A1)
Calacuccia
0
deyottAuthor Commented:
Could I use this if I had the denominator an the numerator in seperate cells? That way I could use formulas to get the denominator an the numerator and just manipulat the display. I am working with a grad student on his thesi that has around 500 records with about 12 fields each. We really don't want to do the math by hand, we want the fraction to update as we add info. Thanks!
For example, imagine your denominators are in column A, and numerators in column B, starting on line 1, you could use this formula, in cell C1 and copied down to show all fractions as you like:
=A1 & "/" & B1
A1 and B1 can contain any number and can be the result of formula's, so the cells in column C will be automatically updated.
In this example, I could imagine a set of formula's in column A & B, and the showed fraction in column C.
Now all you would have to do in that case is the hide columns A & B. The formula's will still be calculated and you still refer to those cells in further formula's.
Maybe that's what you are looking for ?
Calacuccia
0
deyottAuthor Commented:
Yes that would work. I don't know why I didn't think of that! Thanks for much for your input. Can you tell me how I can award you more points for your effort?
You're Wellcome. Actually, I did not think of that initially neither, it was just your last comment which "ringed a bell"
If you want to award more points, you can just add a new question in the MSOffice area, entitled 'For Calacuccia' and you assign the number of points you like.
You don't have to, though, I was glad to find some workaround.
Cheers
Calacuccia
0
Featured Post
The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.
Unfortunately this is impossible, as Excel will automatically transform 3/9 to 1/3 or 0.33333
I'll try to find something, if not maybe someone else will.
Calacuccia