How do I display fractions in small characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use excell all the time to track employee time off. Is there any way in
Excel to auto format fractions, as I do in Word, so that they shrink to
smaller characters when I type them in?
 
You can create AutoCorrect entries which will make the changes you want.

Use Tools>AutoCorrect Options...>Replace: 1/4 > With: Alt+0188

You'll need to decide whether this causes more problems than it's worth, because
it will also change a date like Jan 4/05 (1/4/05) to ¼/05.
 

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

Back
Top