Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you stack fractionsin excel?
How do you stack fractionsin excel?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you stack fractionsin excel?
What do mean by "stack fractions"? What do you want to do? HTH Otto
"excel fraction fromatting" <excel fraction wrote in message ... How do you stack fractionsin excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you stack fractionsin excel?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
excel viewer | Setting up and Configuration of Excel | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) |