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
|