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

D

drywall steve

I want to have fractions displayed in smaller text than whole numbers in
excel 2003
 
D

Dave Peterson

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

Top