How do I Format fractions as fraction characters in Excel 2003?

  • Thread starter Thread starter drywall steve
  • Start date Start date
D

drywall steve

I want to have fractions displayed in smaller text than whole numbers in
excel 2003
 
Numbers (and formulas) don't allow this kind of formatting.

You'd have to use text (precede your entry with an apostrophe or pre-format the
cell as text, then enter the value) and then you could do it.

Select the characters you want to format differently in the formula bar
Format|Cells|Font tab
and make the changes you like.
 

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

Fractions 4
Formatting Fractions 3
Excel Excel and Fractions 3
Convert Decimal fractions to binary and vice versa 1
How do I stop Excel from 'interpreting' my data? 7
How to format numbers as architectural fractions (1/16,1/8,1/4 ) 5
problem with fractions to decimal 1
Not reduce fractions 8

Back
Top