fractions

[smakee]

How do I make the fractions appear with the top first number above the
second, rather than beside, so looking like this "3 ½" rather than this " 3
1/2"?

 

[Dave Peterson]

There are some fonts that have some fractions that allow you do to this.

But those entries will no longer be numeric--you won't be able to do any
arithmetic against them.

But if that's ok, you could use an Arial font and a formula of =char(188) to
show 1/2.

 

[Dave Peterson]

ps. Or use Insert|Symbol if you're using xl2002+