Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fractions
Hi,
Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V |
#2
|
|||
|
|||
You can create a custom format:
<Format <Cells <Number tab, Click on "Fractions", and choose your format. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "V" wrote in message ... Hi, Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V |
#3
|
|||
|
|||
Hi
I have the same problem and this is not an answer. When I type in a fraction I do not want it reduced to the LCD. How do I stop Excel reducing to the LCD. I am using Excel 2000. Regards twa14 "Ragdyer" wrote: You can create a custom format: <Format <Cells <Number tab, Click on "Fractions", and choose your format. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "V" wrote in message ... Hi, Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V |
#4
|
|||
|
|||
Hi
Check out the folliwing link twa14 http://exceltips.vitalnews.com/Pages..._Reducing.html "V" wrote: Hi, Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V |
#5
|
|||
|
|||
Valerie, for Halves, Quarters, Eighths, Sixteenths, Tenths and Hundreds you can select from the pre-set Fractions formats to avoid having to specify a Custom setting, for the rest then follow as TWA wrote, or you can use the single quote to display text ie '6/8 but that becomes a text display and is not useful for calculations. twa14 Wrote: Hi Check out the folliwing link twa14 http://exceltips.vitalnews.com/Pages..._Reducing.html "V" wrote: Hi, Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=466668 |
#6
|
|||
|
|||
Since you say that you had the *same* problem as the OP. then my answer *is
absolutely* correct ! -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "twa14" wrote in message ... Hi I have the same problem and this is not an answer. When I type in a fraction I do not want it reduced to the LCD. How do I stop Excel reducing to the LCD. I am using Excel 2000. Regards twa14 "Ragdyer" wrote: You can create a custom format: <Format <Cells <Number tab, Click on "Fractions", and choose your format. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "V" wrote in message ... Hi, Is there anyway to prevent Excel from reducing fractions? For example, I need 2/4 to appear in my spreadsheet, but Excel is reducing it to 1/2. Thanks, V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fractions: summing numerators and denomerators separately | Excel Discussion (Misc queries) | |||
Changing proper fractions to improper. | Excel Discussion (Misc queries) | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
Fractions to Decimals problem | Excel Discussion (Misc queries) | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) |