Fractions

A

Angel1

Im workind with fractions, I need my fraction info show with the whole number
in one size, and the fraction is a smaller size. Is the re any way I can do
that?
Im workin with excel 2003
 
B

Bob Phillips

Format as

0 ?/?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

David McRitchie

Hi Angel1,
You would have to format as text and then it would no longer be a number,
and it would no longer be formula..

You can format part of a text string from the formula bar, but to actually
get the effect you want in Excel would be even more complicated as
you would have to merge cells vertically for the whole number and
use unmerged cells for the numerator and denominator. unless
you want 1/2, 1/4, 3/4 which are characters themselves..
 
J

James Silverton

Hello, Angel1!
You wrote on Tue, 17 Oct 2006 10:49:03 -0700:

A> Im workind with fractions, I need my fraction info show with
A> the whole number in one size, and the fraction is a smaller
A> size. Is the re any way I can do that?
A> Im workin with excel 2003
A> --
A> Angel1

I guess you know about fraction format. Unfortunately, tho it
will give 3 digits, it will only work for the fractional part of
the number. Thus 3.17578125 is 3 45/256 and that is how it will
display, not 813/256. I believe the last is what you wanted.
The arithmetic terminology talks about "proper" and "improper"
fractions but I can never remember which is which! I'm not too
good on numerator and denominator either :)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top