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"?

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.

smakee wrote:

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

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

Dave Peterson wrote:

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.

smakee wrote:

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

--

Dave Peterson