Changing proper fractions to improper.

G

Guest

Hi.
I've looked through Excel's Help Index but can't find how to set Excel so
that it displays proper fractions to improper. I've already set it so it show
fractions and not decimals.

E.g: I type in 7/3 but Excel formats it to read 1 2/3. I'd prefer to have
this display as 7/3 .

Thank-you. (I have Excel 97 but please tell me the solution for any version
as I will have access to Excel XP soon.)
 

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.

Ask a Question

Similar Threads

How do I convert a fraction to its true decimal, not a date no. 2
Fractions to Decimals problem 1
architectural fractions 8
How to prevent Excel converting imported fractions into dates 6
decimals or fractions 1
URGENT: Function Results in Fractions 3
Formating fractions so they read like a measuring tape 1
fractions in forms & cells (not DATES & Decimals) 1

Top