From the Excel main menu:
<format><cells><number tab>
Category: Fraction
Type: (select whatever is appropriate)
Click [OK]
In your example (12/16),
if you had selected the Type: Up to 3 digits
The cell would display as 3/4
If the cell contained 0.1328125, it would display as 17/128
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.