Thread: fractions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default fractions

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