How do I display exact fractions instead of decimals?

G

Guest

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.
Click to expand...

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

Similar Threads

How do I stop fractions from being reduced? 3
Fractions to Decimals problem 1
How to show repeating decimals line 1
How do I get excel to NOT auto reduce fractions. 2
Formatting Fractions 3
disperse amount across multiple cells without fractions 3
How to prevent Excel converting imported fractions into dates 6
decimals or fractions 1

Top