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

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

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

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

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

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