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
|