Reducing fractions

R

Rob

No need to treat it as text.. Excel has a built in number
format called.. umm FRACTION.
Format the cell as fraction; there are several choices
there
 
R

Ron Rosenfeld

No need to treat it as text.. Excel has a built in number
format called.. umm FRACTION.
Format the cell as fraction; there are several choices
there


What single format would you use to have all of the following display AS
ENTERED:

3 16/20
5 14/16
13 12/32
3 7/8


--ron
 

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