Thread: Fractions
View Single Post
  #6   Report Post  
RagDyeR
 
Posts: n/a
Default

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