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.
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

Mail Merge - displaying a conditional number of decimals 5
disperse amount across multiple cells without fractions 3
Formatting Fractions 3
How do I get excel to NOT auto reduce fractions. 2
How do I combine/join multiple formulas 2
How do I stop fractions from being reduced? 3
How to show repeating decimals line 1
Fractions to Decimals problem 1

Top