How do I display exact fractions instead of decimals?

H

Hawk

How do I display exact fractions instead of being reduced, or changed to a
decimal? I am doing a spreadsheet which has fractions to describe some
things, and Excel either reduces the fraction (ex. 3/6 to 1/2, or 2/2 to 1)
or enters it as a decimal (ex. 2/5 to 0.4). How do I stop it from doing
this? I didn't want to store the fractions as text because i'm not sure if
they will then work in formulas.
 
D

Dana DeLouis

As fractions, I think the best you can do is have a fixed denominator in a
custom format:
??/6

This will display 0.5 as "3/6"

HTH. :>)
 
S

Saxman

Hawk said:
How do I display exact fractions instead of being reduced, or changed to a
decimal? I am doing a spreadsheet which has fractions to describe some
things, and Excel either reduces the fraction (ex. 3/6 to 1/2, or 2/2 to 1)
or enters it as a decimal (ex. 2/5 to 0.4). How do I stop it from doing
this? I didn't want to store the fractions as text because i'm not sure if
they will then work in formulas.

Format the column as text.
 

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