View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How do you stack fractionsin excel?

Perhaps the OP means complex fractions, i.e., 1/2 / 3/4 ??

I'm not aware of any way to display that other than in decimal form.

Dave
--
Brevity is the soul of wit.


"Fred" wrote:

I'm guessing you mean "display" fractions, i.e. stack 1 number on top
of another.

On the Format menu, click Cells.
On the Number tab, click Fraction in the Category list.
In the Type list, click the fraction format type that you want to use.
Available fraction formats


Fraction format This format displays 123.456 as
Single-digit fraction 123 1/2, rounding to the nearest single-digit
fraction value
Double-digit fraction 123 26/57, rounding to the nearest double-digit
fraction value
Triple-digit fraction 123 57/125, rounding to the nearest triple-digit
fraction value
Fraction as halves 123 1/2
Fraction as quarters 123 2/4
Fraction as eighths 123 4/8
Fraction as sixteenths 123 7/16
Fraction as tenths 123 5/10
Fraction as hundredths 123 46/100


Regards
Fred