Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do you stack fractionsin excel?

How do you stack fractionsin excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,090
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Open Excel 2003 from Windows Explorer pmpjr Excel Discussion (Misc queries) 9 September 11th 06 03:58 PM
excel viewer littlebird0770 Setting up and Configuration of Excel 6 July 6th 06 04:10 PM
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
Excel Open Dialog Improper Sort [email protected] Excel Discussion (Misc queries) 4 May 17th 06 02:40 PM


All times are GMT +1. The time now is 01:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"