Changing proper fractions to improper.

A

apersonoutthere

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

Finding the proper style field and the numbered paragraph value within the style 0
architectural fractions 8
How do I convert a fraction to its true decimal, not a date no. 2
Merging from an Excel file with graphics 1
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Changing language for spell check not working? 1
Dumb question alert! What program to use? 0

Top